package com.hrd.mybatis.bean.auto;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class TMLDayWorkBillExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected int limitStart = -1;

    protected int limitEnd = -1;

    public TMLDayWorkBillExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void setLimitStart(int limitStart) {
        this.limitStart=limitStart;
    }

    public int getLimitStart() {
        return limitStart;
    }

    public void setLimitEnd(int limitEnd) {
        this.limitEnd=limitEnd;
    }

    public int getLimitEnd() {
        return limitEnd;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andFidIsNull() {
            addCriterion("fID is null");
            return (Criteria) this;
        }

        public Criteria andFidIsNotNull() {
            addCriterion("fID is not null");
            return (Criteria) this;
        }

        public Criteria andFidEqualTo(Integer value) {
            addCriterion("fID =", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidNotEqualTo(Integer value) {
            addCriterion("fID <>", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidGreaterThan(Integer value) {
            addCriterion("fID >", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fID >=", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidLessThan(Integer value) {
            addCriterion("fID <", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidLessThanOrEqualTo(Integer value) {
            addCriterion("fID <=", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidIn(List<Integer> values) {
            addCriterion("fID in", values, "fid");
            return (Criteria) this;
        }

        public Criteria andFidNotIn(List<Integer> values) {
            addCriterion("fID not in", values, "fid");
            return (Criteria) this;
        }

        public Criteria andFidBetween(Integer value1, Integer value2) {
            addCriterion("fID between", value1, value2, "fid");
            return (Criteria) this;
        }

        public Criteria andFidNotBetween(Integer value1, Integer value2) {
            addCriterion("fID not between", value1, value2, "fid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidIsNull() {
            addCriterion("fItemClassID is null");
            return (Criteria) this;
        }

        public Criteria andFitemclassidIsNotNull() {
            addCriterion("fItemClassID is not null");
            return (Criteria) this;
        }

        public Criteria andFitemclassidEqualTo(Integer value) {
            addCriterion("fItemClassID =", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidNotEqualTo(Integer value) {
            addCriterion("fItemClassID <>", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidGreaterThan(Integer value) {
            addCriterion("fItemClassID >", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fItemClassID >=", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidLessThan(Integer value) {
            addCriterion("fItemClassID <", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidLessThanOrEqualTo(Integer value) {
            addCriterion("fItemClassID <=", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidIn(List<Integer> values) {
            addCriterion("fItemClassID in", values, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidNotIn(List<Integer> values) {
            addCriterion("fItemClassID not in", values, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidBetween(Integer value1, Integer value2) {
            addCriterion("fItemClassID between", value1, value2, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidNotBetween(Integer value1, Integer value2) {
            addCriterion("fItemClassID not between", value1, value2, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidIsNull() {
            addCriterion("fCompanyID is null");
            return (Criteria) this;
        }

        public Criteria andFcompanyidIsNotNull() {
            addCriterion("fCompanyID is not null");
            return (Criteria) this;
        }

        public Criteria andFcompanyidEqualTo(Integer value) {
            addCriterion("fCompanyID =", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidNotEqualTo(Integer value) {
            addCriterion("fCompanyID <>", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidGreaterThan(Integer value) {
            addCriterion("fCompanyID >", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fCompanyID >=", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidLessThan(Integer value) {
            addCriterion("fCompanyID <", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidLessThanOrEqualTo(Integer value) {
            addCriterion("fCompanyID <=", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidIn(List<Integer> values) {
            addCriterion("fCompanyID in", values, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidNotIn(List<Integer> values) {
            addCriterion("fCompanyID not in", values, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidBetween(Integer value1, Integer value2) {
            addCriterion("fCompanyID between", value1, value2, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidNotBetween(Integer value1, Integer value2) {
            addCriterion("fCompanyID not between", value1, value2, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFnoIsNull() {
            addCriterion("fNO is null");
            return (Criteria) this;
        }

        public Criteria andFnoIsNotNull() {
            addCriterion("fNO is not null");
            return (Criteria) this;
        }

        public Criteria andFnoEqualTo(String value) {
            addCriterion("fNO =", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoNotEqualTo(String value) {
            addCriterion("fNO <>", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoGreaterThan(String value) {
            addCriterion("fNO >", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoGreaterThanOrEqualTo(String value) {
            addCriterion("fNO >=", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoLessThan(String value) {
            addCriterion("fNO <", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoLessThanOrEqualTo(String value) {
            addCriterion("fNO <=", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoLike(String value) {
            addCriterion("fNO like", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoNotLike(String value) {
            addCriterion("fNO not like", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoIn(List<String> values) {
            addCriterion("fNO in", values, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoNotIn(List<String> values) {
            addCriterion("fNO not in", values, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoBetween(String value1, String value2) {
            addCriterion("fNO between", value1, value2, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoNotBetween(String value1, String value2) {
            addCriterion("fNO not between", value1, value2, "fno");
            return (Criteria) this;
        }

        public Criteria andFnameIsNull() {
            addCriterion("fName is null");
            return (Criteria) this;
        }

        public Criteria andFnameIsNotNull() {
            addCriterion("fName is not null");
            return (Criteria) this;
        }

        public Criteria andFnameEqualTo(String value) {
            addCriterion("fName =", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameNotEqualTo(String value) {
            addCriterion("fName <>", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameGreaterThan(String value) {
            addCriterion("fName >", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameGreaterThanOrEqualTo(String value) {
            addCriterion("fName >=", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameLessThan(String value) {
            addCriterion("fName <", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameLessThanOrEqualTo(String value) {
            addCriterion("fName <=", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameLike(String value) {
            addCriterion("fName like", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameNotLike(String value) {
            addCriterion("fName not like", value, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameIn(List<String> values) {
            addCriterion("fName in", values, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameNotIn(List<String> values) {
            addCriterion("fName not in", values, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameBetween(String value1, String value2) {
            addCriterion("fName between", value1, value2, "fname");
            return (Criteria) this;
        }

        public Criteria andFnameNotBetween(String value1, String value2) {
            addCriterion("fName not between", value1, value2, "fname");
            return (Criteria) this;
        }

        public Criteria andFpidIsNull() {
            addCriterion("fPID is null");
            return (Criteria) this;
        }

        public Criteria andFpidIsNotNull() {
            addCriterion("fPID is not null");
            return (Criteria) this;
        }

        public Criteria andFpidEqualTo(Integer value) {
            addCriterion("fPID =", value, "fpid");
            return (Criteria) this;
        }

        public Criteria andFpidNotEqualTo(Integer value) {
            addCriterion("fPID <>", value, "fpid");
            return (Criteria) this;
        }

        public Criteria andFpidGreaterThan(Integer value) {
            addCriterion("fPID >", value, "fpid");
            return (Criteria) this;
        }

        public Criteria andFpidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fPID >=", value, "fpid");
            return (Criteria) this;
        }

        public Criteria andFpidLessThan(Integer value) {
            addCriterion("fPID <", value, "fpid");
            return (Criteria) this;
        }

        public Criteria andFpidLessThanOrEqualTo(Integer value) {
            addCriterion("fPID <=", value, "fpid");
            return (Criteria) this;
        }

        public Criteria andFpidIn(List<Integer> values) {
            addCriterion("fPID in", values, "fpid");
            return (Criteria) this;
        }

        public Criteria andFpidNotIn(List<Integer> values) {
            addCriterion("fPID not in", values, "fpid");
            return (Criteria) this;
        }

        public Criteria andFpidBetween(Integer value1, Integer value2) {
            addCriterion("fPID between", value1, value2, "fpid");
            return (Criteria) this;
        }

        public Criteria andFpidNotBetween(Integer value1, Integer value2) {
            addCriterion("fPID not between", value1, value2, "fpid");
            return (Criteria) this;
        }

        public Criteria andFfullnameIsNull() {
            addCriterion("fFullName is null");
            return (Criteria) this;
        }

        public Criteria andFfullnameIsNotNull() {
            addCriterion("fFullName is not null");
            return (Criteria) this;
        }

        public Criteria andFfullnameEqualTo(String value) {
            addCriterion("fFullName =", value, "ffullname");
            return (Criteria) this;
        }

        public Criteria andFfullnameNotEqualTo(String value) {
            addCriterion("fFullName <>", value, "ffullname");
            return (Criteria) this;
        }

        public Criteria andFfullnameGreaterThan(String value) {
            addCriterion("fFullName >", value, "ffullname");
            return (Criteria) this;
        }

        public Criteria andFfullnameGreaterThanOrEqualTo(String value) {
            addCriterion("fFullName >=", value, "ffullname");
            return (Criteria) this;
        }

        public Criteria andFfullnameLessThan(String value) {
            addCriterion("fFullName <", value, "ffullname");
            return (Criteria) this;
        }

        public Criteria andFfullnameLessThanOrEqualTo(String value) {
            addCriterion("fFullName <=", value, "ffullname");
            return (Criteria) this;
        }

        public Criteria andFfullnameLike(String value) {
            addCriterion("fFullName like", value, "ffullname");
            return (Criteria) this;
        }

        public Criteria andFfullnameNotLike(String value) {
            addCriterion("fFullName not like", value, "ffullname");
            return (Criteria) this;
        }

        public Criteria andFfullnameIn(List<String> values) {
            addCriterion("fFullName in", values, "ffullname");
            return (Criteria) this;
        }

        public Criteria andFfullnameNotIn(List<String> values) {
            addCriterion("fFullName not in", values, "ffullname");
            return (Criteria) this;
        }

        public Criteria andFfullnameBetween(String value1, String value2) {
            addCriterion("fFullName between", value1, value2, "ffullname");
            return (Criteria) this;
        }

        public Criteria andFfullnameNotBetween(String value1, String value2) {
            addCriterion("fFullName not between", value1, value2, "ffullname");
            return (Criteria) this;
        }

        public Criteria andFlevelIsNull() {
            addCriterion("fLevel is null");
            return (Criteria) this;
        }

        public Criteria andFlevelIsNotNull() {
            addCriterion("fLevel is not null");
            return (Criteria) this;
        }

        public Criteria andFlevelEqualTo(Integer value) {
            addCriterion("fLevel =", value, "flevel");
            return (Criteria) this;
        }

        public Criteria andFlevelNotEqualTo(Integer value) {
            addCriterion("fLevel <>", value, "flevel");
            return (Criteria) this;
        }

        public Criteria andFlevelGreaterThan(Integer value) {
            addCriterion("fLevel >", value, "flevel");
            return (Criteria) this;
        }

        public Criteria andFlevelGreaterThanOrEqualTo(Integer value) {
            addCriterion("fLevel >=", value, "flevel");
            return (Criteria) this;
        }

        public Criteria andFlevelLessThan(Integer value) {
            addCriterion("fLevel <", value, "flevel");
            return (Criteria) this;
        }

        public Criteria andFlevelLessThanOrEqualTo(Integer value) {
            addCriterion("fLevel <=", value, "flevel");
            return (Criteria) this;
        }

        public Criteria andFlevelIn(List<Integer> values) {
            addCriterion("fLevel in", values, "flevel");
            return (Criteria) this;
        }

        public Criteria andFlevelNotIn(List<Integer> values) {
            addCriterion("fLevel not in", values, "flevel");
            return (Criteria) this;
        }

        public Criteria andFlevelBetween(Integer value1, Integer value2) {
            addCriterion("fLevel between", value1, value2, "flevel");
            return (Criteria) this;
        }

        public Criteria andFlevelNotBetween(Integer value1, Integer value2) {
            addCriterion("fLevel not between", value1, value2, "flevel");
            return (Criteria) this;
        }

        public Criteria andFdetailIsNull() {
            addCriterion("fDetail is null");
            return (Criteria) this;
        }

        public Criteria andFdetailIsNotNull() {
            addCriterion("fDetail is not null");
            return (Criteria) this;
        }

        private Criteria andFdetailEqualTo_back(Boolean value) {
            addCriterion("fDetail =", value, "fdetail");
            return (Criteria) this;
        }

        private Criteria andFdetailNotEqualTo_back(Boolean value) {
            addCriterion("fDetail <>", value, "fdetail");
            return (Criteria) this;
        }

        private Criteria andFdetailGreaterThan_back(Boolean value) {
            addCriterion("fDetail >", value, "fdetail");
            return (Criteria) this;
        }

        private Criteria andFdetailGreaterThanOrEqualTo_back(Boolean value) {
            addCriterion("fDetail >=", value, "fdetail");
            return (Criteria) this;
        }

        private Criteria andFdetailLessThan_back(Boolean value) {
            addCriterion("fDetail <", value, "fdetail");
            return (Criteria) this;
        }

        private Criteria andFdetailLessThanOrEqualTo_back(Boolean value) {
            addCriterion("fDetail <=", value, "fdetail");
            return (Criteria) this;
        }

        public Criteria andFdetailIn(List<Boolean> values) {
            addCriterion("fDetail in", values, "fdetail");
            return (Criteria) this;
        }

        public Criteria andFdetailNotIn(List<Boolean> values) {
            addCriterion("fDetail not in", values, "fdetail");
            return (Criteria) this;
        }

        private Criteria andFdetailBetween_back(Boolean value1, Boolean value2) {
            addCriterion("fDetail between", value1, value2, "fdetail");
            return (Criteria) this;
        }

        private Criteria andFdetailNotBetween_back(Boolean value1, Boolean value2) {
            addCriterion("fDetail not between", value1, value2, "fdetail");
            return (Criteria) this;
        }

        public Criteria andFdateIsNull() {
            addCriterion("fDate is null");
            return (Criteria) this;
        }

        public Criteria andFdateIsNotNull() {
            addCriterion("fDate is not null");
            return (Criteria) this;
        }

        public Criteria andFdateEqualTo(Date value) {
            addCriterion("fDate =", value, "fdate");
            return (Criteria) this;
        }

        public Criteria andFdateNotEqualTo(Date value) {
            addCriterion("fDate <>", value, "fdate");
            return (Criteria) this;
        }

        public Criteria andFdateGreaterThan(Date value) {
            addCriterion("fDate >", value, "fdate");
            return (Criteria) this;
        }

        public Criteria andFdateGreaterThanOrEqualTo(Date value) {
            addCriterion("fDate >=", value, "fdate");
            return (Criteria) this;
        }

        public Criteria andFdateLessThan(Date value) {
            addCriterion("fDate <", value, "fdate");
            return (Criteria) this;
        }

        public Criteria andFdateLessThanOrEqualTo(Date value) {
            addCriterion("fDate <=", value, "fdate");
            return (Criteria) this;
        }

        public Criteria andFdateIn(List<Date> values) {
            addCriterion("fDate in", values, "fdate");
            return (Criteria) this;
        }

        public Criteria andFdateNotIn(List<Date> values) {
            addCriterion("fDate not in", values, "fdate");
            return (Criteria) this;
        }

        public Criteria andFdateBetween(Date value1, Date value2) {
            addCriterion("fDate between", value1, value2, "fdate");
            return (Criteria) this;
        }

        public Criteria andFdateNotBetween(Date value1, Date value2) {
            addCriterion("fDate not between", value1, value2, "fdate");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidIsNull() {
            addCriterion("fRunStatusID is null");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidIsNotNull() {
            addCriterion("fRunStatusID is not null");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidEqualTo(Integer value) {
            addCriterion("fRunStatusID =", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidNotEqualTo(Integer value) {
            addCriterion("fRunStatusID <>", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidGreaterThan(Integer value) {
            addCriterion("fRunStatusID >", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fRunStatusID >=", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidLessThan(Integer value) {
            addCriterion("fRunStatusID <", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidLessThanOrEqualTo(Integer value) {
            addCriterion("fRunStatusID <=", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidIn(List<Integer> values) {
            addCriterion("fRunStatusID in", values, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidNotIn(List<Integer> values) {
            addCriterion("fRunStatusID not in", values, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidBetween(Integer value1, Integer value2) {
            addCriterion("fRunStatusID between", value1, value2, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidNotBetween(Integer value1, Integer value2) {
            addCriterion("fRunStatusID not between", value1, value2, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFsourceidIsNull() {
            addCriterion("fSourceID is null");
            return (Criteria) this;
        }

        public Criteria andFsourceidIsNotNull() {
            addCriterion("fSourceID is not null");
            return (Criteria) this;
        }

        public Criteria andFsourceidEqualTo(Integer value) {
            addCriterion("fSourceID =", value, "fsourceid");
            return (Criteria) this;
        }

        public Criteria andFsourceidNotEqualTo(Integer value) {
            addCriterion("fSourceID <>", value, "fsourceid");
            return (Criteria) this;
        }

        public Criteria andFsourceidGreaterThan(Integer value) {
            addCriterion("fSourceID >", value, "fsourceid");
            return (Criteria) this;
        }

        public Criteria andFsourceidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fSourceID >=", value, "fsourceid");
            return (Criteria) this;
        }

        public Criteria andFsourceidLessThan(Integer value) {
            addCriterion("fSourceID <", value, "fsourceid");
            return (Criteria) this;
        }

        public Criteria andFsourceidLessThanOrEqualTo(Integer value) {
            addCriterion("fSourceID <=", value, "fsourceid");
            return (Criteria) this;
        }

        public Criteria andFsourceidIn(List<Integer> values) {
            addCriterion("fSourceID in", values, "fsourceid");
            return (Criteria) this;
        }

        public Criteria andFsourceidNotIn(List<Integer> values) {
            addCriterion("fSourceID not in", values, "fsourceid");
            return (Criteria) this;
        }

        public Criteria andFsourceidBetween(Integer value1, Integer value2) {
            addCriterion("fSourceID between", value1, value2, "fsourceid");
            return (Criteria) this;
        }

        public Criteria andFsourceidNotBetween(Integer value1, Integer value2) {
            addCriterion("fSourceID not between", value1, value2, "fsourceid");
            return (Criteria) this;
        }

        public Criteria andFchangedateIsNull() {
            addCriterion("fChangeDate is null");
            return (Criteria) this;
        }

        public Criteria andFchangedateIsNotNull() {
            addCriterion("fChangeDate is not null");
            return (Criteria) this;
        }

        public Criteria andFchangedateEqualTo(Date value) {
            addCriterion("fChangeDate =", value, "fchangedate");
            return (Criteria) this;
        }

        public Criteria andFchangedateNotEqualTo(Date value) {
            addCriterion("fChangeDate <>", value, "fchangedate");
            return (Criteria) this;
        }

        public Criteria andFchangedateGreaterThan(Date value) {
            addCriterion("fChangeDate >", value, "fchangedate");
            return (Criteria) this;
        }

        public Criteria andFchangedateGreaterThanOrEqualTo(Date value) {
            addCriterion("fChangeDate >=", value, "fchangedate");
            return (Criteria) this;
        }

        public Criteria andFchangedateLessThan(Date value) {
            addCriterion("fChangeDate <", value, "fchangedate");
            return (Criteria) this;
        }

        public Criteria andFchangedateLessThanOrEqualTo(Date value) {
            addCriterion("fChangeDate <=", value, "fchangedate");
            return (Criteria) this;
        }

        public Criteria andFchangedateIn(List<Date> values) {
            addCriterion("fChangeDate in", values, "fchangedate");
            return (Criteria) this;
        }

        public Criteria andFchangedateNotIn(List<Date> values) {
            addCriterion("fChangeDate not in", values, "fchangedate");
            return (Criteria) this;
        }

        public Criteria andFchangedateBetween(Date value1, Date value2) {
            addCriterion("fChangeDate between", value1, value2, "fchangedate");
            return (Criteria) this;
        }

        public Criteria andFchangedateNotBetween(Date value1, Date value2) {
            addCriterion("fChangeDate not between", value1, value2, "fchangedate");
            return (Criteria) this;
        }

        public Criteria andFchangereasonIsNull() {
            addCriterion("fChangeReason is null");
            return (Criteria) this;
        }

        public Criteria andFchangereasonIsNotNull() {
            addCriterion("fChangeReason is not null");
            return (Criteria) this;
        }

        public Criteria andFchangereasonEqualTo(String value) {
            addCriterion("fChangeReason =", value, "fchangereason");
            return (Criteria) this;
        }

        public Criteria andFchangereasonNotEqualTo(String value) {
            addCriterion("fChangeReason <>", value, "fchangereason");
            return (Criteria) this;
        }

        public Criteria andFchangereasonGreaterThan(String value) {
            addCriterion("fChangeReason >", value, "fchangereason");
            return (Criteria) this;
        }

        public Criteria andFchangereasonGreaterThanOrEqualTo(String value) {
            addCriterion("fChangeReason >=", value, "fchangereason");
            return (Criteria) this;
        }

        public Criteria andFchangereasonLessThan(String value) {
            addCriterion("fChangeReason <", value, "fchangereason");
            return (Criteria) this;
        }

        public Criteria andFchangereasonLessThanOrEqualTo(String value) {
            addCriterion("fChangeReason <=", value, "fchangereason");
            return (Criteria) this;
        }

        public Criteria andFchangereasonLike(String value) {
            addCriterion("fChangeReason like", value, "fchangereason");
            return (Criteria) this;
        }

        public Criteria andFchangereasonNotLike(String value) {
            addCriterion("fChangeReason not like", value, "fchangereason");
            return (Criteria) this;
        }

        public Criteria andFchangereasonIn(List<String> values) {
            addCriterion("fChangeReason in", values, "fchangereason");
            return (Criteria) this;
        }

        public Criteria andFchangereasonNotIn(List<String> values) {
            addCriterion("fChangeReason not in", values, "fchangereason");
            return (Criteria) this;
        }

        public Criteria andFchangereasonBetween(String value1, String value2) {
            addCriterion("fChangeReason between", value1, value2, "fchangereason");
            return (Criteria) this;
        }

        public Criteria andFchangereasonNotBetween(String value1, String value2) {
            addCriterion("fChangeReason not between", value1, value2, "fchangereason");
            return (Criteria) this;
        }

        public Criteria andFstatusidIsNull() {
            addCriterion("fStatusID is null");
            return (Criteria) this;
        }

        public Criteria andFstatusidIsNotNull() {
            addCriterion("fStatusID is not null");
            return (Criteria) this;
        }

        public Criteria andFstatusidEqualTo(Integer value) {
            addCriterion("fStatusID =", value, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidNotEqualTo(Integer value) {
            addCriterion("fStatusID <>", value, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidGreaterThan(Integer value) {
            addCriterion("fStatusID >", value, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fStatusID >=", value, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidLessThan(Integer value) {
            addCriterion("fStatusID <", value, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidLessThanOrEqualTo(Integer value) {
            addCriterion("fStatusID <=", value, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidIn(List<Integer> values) {
            addCriterion("fStatusID in", values, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidNotIn(List<Integer> values) {
            addCriterion("fStatusID not in", values, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidBetween(Integer value1, Integer value2) {
            addCriterion("fStatusID between", value1, value2, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidNotBetween(Integer value1, Integer value2) {
            addCriterion("fStatusID not between", value1, value2, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFmemoIsNull() {
            addCriterion("fMemo is null");
            return (Criteria) this;
        }

        public Criteria andFmemoIsNotNull() {
            addCriterion("fMemo is not null");
            return (Criteria) this;
        }

        public Criteria andFmemoEqualTo(String value) {
            addCriterion("fMemo =", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoNotEqualTo(String value) {
            addCriterion("fMemo <>", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoGreaterThan(String value) {
            addCriterion("fMemo >", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoGreaterThanOrEqualTo(String value) {
            addCriterion("fMemo >=", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoLessThan(String value) {
            addCriterion("fMemo <", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoLessThanOrEqualTo(String value) {
            addCriterion("fMemo <=", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoLike(String value) {
            addCriterion("fMemo like", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoNotLike(String value) {
            addCriterion("fMemo not like", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoIn(List<String> values) {
            addCriterion("fMemo in", values, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoNotIn(List<String> values) {
            addCriterion("fMemo not in", values, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoBetween(String value1, String value2) {
            addCriterion("fMemo between", value1, value2, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoNotBetween(String value1, String value2) {
            addCriterion("fMemo not between", value1, value2, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFarchivesidIsNull() {
            addCriterion("fArchivesID is null");
            return (Criteria) this;
        }

        public Criteria andFarchivesidIsNotNull() {
            addCriterion("fArchivesID is not null");
            return (Criteria) this;
        }

        public Criteria andFarchivesidEqualTo(Integer value) {
            addCriterion("fArchivesID =", value, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFarchivesidNotEqualTo(Integer value) {
            addCriterion("fArchivesID <>", value, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFarchivesidGreaterThan(Integer value) {
            addCriterion("fArchivesID >", value, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFarchivesidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fArchivesID >=", value, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFarchivesidLessThan(Integer value) {
            addCriterion("fArchivesID <", value, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFarchivesidLessThanOrEqualTo(Integer value) {
            addCriterion("fArchivesID <=", value, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFarchivesidIn(List<Integer> values) {
            addCriterion("fArchivesID in", values, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFarchivesidNotIn(List<Integer> values) {
            addCriterion("fArchivesID not in", values, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFarchivesidBetween(Integer value1, Integer value2) {
            addCriterion("fArchivesID between", value1, value2, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFarchivesidNotBetween(Integer value1, Integer value2) {
            addCriterion("fArchivesID not between", value1, value2, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFvarcharIsNull() {
            addCriterion("fVarchar is null");
            return (Criteria) this;
        }

        public Criteria andFvarcharIsNotNull() {
            addCriterion("fVarchar is not null");
            return (Criteria) this;
        }

        public Criteria andFvarcharEqualTo(String value) {
            addCriterion("fVarchar =", value, "fvarchar");
            return (Criteria) this;
        }

        public Criteria andFvarcharNotEqualTo(String value) {
            addCriterion("fVarchar <>", value, "fvarchar");
            return (Criteria) this;
        }

        public Criteria andFvarcharGreaterThan(String value) {
            addCriterion("fVarchar >", value, "fvarchar");
            return (Criteria) this;
        }

        public Criteria andFvarcharGreaterThanOrEqualTo(String value) {
            addCriterion("fVarchar >=", value, "fvarchar");
            return (Criteria) this;
        }

        public Criteria andFvarcharLessThan(String value) {
            addCriterion("fVarchar <", value, "fvarchar");
            return (Criteria) this;
        }

        public Criteria andFvarcharLessThanOrEqualTo(String value) {
            addCriterion("fVarchar <=", value, "fvarchar");
            return (Criteria) this;
        }

        public Criteria andFvarcharLike(String value) {
            addCriterion("fVarchar like", value, "fvarchar");
            return (Criteria) this;
        }

        public Criteria andFvarcharNotLike(String value) {
            addCriterion("fVarchar not like", value, "fvarchar");
            return (Criteria) this;
        }

        public Criteria andFvarcharIn(List<String> values) {
            addCriterion("fVarchar in", values, "fvarchar");
            return (Criteria) this;
        }

        public Criteria andFvarcharNotIn(List<String> values) {
            addCriterion("fVarchar not in", values, "fvarchar");
            return (Criteria) this;
        }

        public Criteria andFvarcharBetween(String value1, String value2) {
            addCriterion("fVarchar between", value1, value2, "fvarchar");
            return (Criteria) this;
        }

        public Criteria andFvarcharNotBetween(String value1, String value2) {
            addCriterion("fVarchar not between", value1, value2, "fvarchar");
            return (Criteria) this;
        }

        public Criteria andFkjdateIsNull() {
            addCriterion("fKJDate is null");
            return (Criteria) this;
        }

        public Criteria andFkjdateIsNotNull() {
            addCriterion("fKJDate is not null");
            return (Criteria) this;
        }

        public Criteria andFkjdateEqualTo(Date value) {
            addCriterion("fKJDate =", value, "fkjdate");
            return (Criteria) this;
        }

        public Criteria andFkjdateNotEqualTo(Date value) {
            addCriterion("fKJDate <>", value, "fkjdate");
            return (Criteria) this;
        }

        public Criteria andFkjdateGreaterThan(Date value) {
            addCriterion("fKJDate >", value, "fkjdate");
            return (Criteria) this;
        }

        public Criteria andFkjdateGreaterThanOrEqualTo(Date value) {
            addCriterion("fKJDate >=", value, "fkjdate");
            return (Criteria) this;
        }

        public Criteria andFkjdateLessThan(Date value) {
            addCriterion("fKJDate <", value, "fkjdate");
            return (Criteria) this;
        }

        public Criteria andFkjdateLessThanOrEqualTo(Date value) {
            addCriterion("fKJDate <=", value, "fkjdate");
            return (Criteria) this;
        }

        public Criteria andFkjdateIn(List<Date> values) {
            addCriterion("fKJDate in", values, "fkjdate");
            return (Criteria) this;
        }

        public Criteria andFkjdateNotIn(List<Date> values) {
            addCriterion("fKJDate not in", values, "fkjdate");
            return (Criteria) this;
        }

        public Criteria andFkjdateBetween(Date value1, Date value2) {
            addCriterion("fKJDate between", value1, value2, "fkjdate");
            return (Criteria) this;
        }

        public Criteria andFkjdateNotBetween(Date value1, Date value2) {
            addCriterion("fKJDate not between", value1, value2, "fkjdate");
            return (Criteria) this;
        }

        public Criteria andFhjdateIsNull() {
            addCriterion("fHJDate is null");
            return (Criteria) this;
        }

        public Criteria andFhjdateIsNotNull() {
            addCriterion("fHJDate is not null");
            return (Criteria) this;
        }

        public Criteria andFhjdateEqualTo(Date value) {
            addCriterion("fHJDate =", value, "fhjdate");
            return (Criteria) this;
        }

        public Criteria andFhjdateNotEqualTo(Date value) {
            addCriterion("fHJDate <>", value, "fhjdate");
            return (Criteria) this;
        }

        public Criteria andFhjdateGreaterThan(Date value) {
            addCriterion("fHJDate >", value, "fhjdate");
            return (Criteria) this;
        }

        public Criteria andFhjdateGreaterThanOrEqualTo(Date value) {
            addCriterion("fHJDate >=", value, "fhjdate");
            return (Criteria) this;
        }

        public Criteria andFhjdateLessThan(Date value) {
            addCriterion("fHJDate <", value, "fhjdate");
            return (Criteria) this;
        }

        public Criteria andFhjdateLessThanOrEqualTo(Date value) {
            addCriterion("fHJDate <=", value, "fhjdate");
            return (Criteria) this;
        }

        public Criteria andFhjdateIn(List<Date> values) {
            addCriterion("fHJDate in", values, "fhjdate");
            return (Criteria) this;
        }

        public Criteria andFhjdateNotIn(List<Date> values) {
            addCriterion("fHJDate not in", values, "fhjdate");
            return (Criteria) this;
        }

        public Criteria andFhjdateBetween(Date value1, Date value2) {
            addCriterion("fHJDate between", value1, value2, "fhjdate");
            return (Criteria) this;
        }

        public Criteria andFhjdateNotBetween(Date value1, Date value2) {
            addCriterion("fHJDate not between", value1, value2, "fhjdate");
            return (Criteria) this;
        }

        public Criteria andHjdateIsNull() {
            addCriterion("HJDate is null");
            return (Criteria) this;
        }

        public Criteria andHjdateIsNotNull() {
            addCriterion("HJDate is not null");
            return (Criteria) this;
        }

        public Criteria andHjdateEqualTo(Date value) {
            addCriterion("HJDate =", value, "hjdate");
            return (Criteria) this;
        }

        public Criteria andHjdateNotEqualTo(Date value) {
            addCriterion("HJDate <>", value, "hjdate");
            return (Criteria) this;
        }

        public Criteria andHjdateGreaterThan(Date value) {
            addCriterion("HJDate >", value, "hjdate");
            return (Criteria) this;
        }

        public Criteria andHjdateGreaterThanOrEqualTo(Date value) {
            addCriterion("HJDate >=", value, "hjdate");
            return (Criteria) this;
        }

        public Criteria andHjdateLessThan(Date value) {
            addCriterion("HJDate <", value, "hjdate");
            return (Criteria) this;
        }

        public Criteria andHjdateLessThanOrEqualTo(Date value) {
            addCriterion("HJDate <=", value, "hjdate");
            return (Criteria) this;
        }

        public Criteria andHjdateIn(List<Date> values) {
            addCriterion("HJDate in", values, "hjdate");
            return (Criteria) this;
        }

        public Criteria andHjdateNotIn(List<Date> values) {
            addCriterion("HJDate not in", values, "hjdate");
            return (Criteria) this;
        }

        public Criteria andHjdateBetween(Date value1, Date value2) {
            addCriterion("HJDate between", value1, value2, "hjdate");
            return (Criteria) this;
        }

        public Criteria andHjdateNotBetween(Date value1, Date value2) {
            addCriterion("HJDate not between", value1, value2, "hjdate");
            return (Criteria) this;
        }

        public Criteria andFfkjdateIsNull() {
            addCriterion("ffKJDate is null");
            return (Criteria) this;
        }

        public Criteria andFfkjdateIsNotNull() {
            addCriterion("ffKJDate is not null");
            return (Criteria) this;
        }

        public Criteria andFfkjdateEqualTo(Date value) {
            addCriterion("ffKJDate =", value, "ffkjdate");
            return (Criteria) this;
        }

        public Criteria andFfkjdateNotEqualTo(Date value) {
            addCriterion("ffKJDate <>", value, "ffkjdate");
            return (Criteria) this;
        }

        public Criteria andFfkjdateGreaterThan(Date value) {
            addCriterion("ffKJDate >", value, "ffkjdate");
            return (Criteria) this;
        }

        public Criteria andFfkjdateGreaterThanOrEqualTo(Date value) {
            addCriterion("ffKJDate >=", value, "ffkjdate");
            return (Criteria) this;
        }

        public Criteria andFfkjdateLessThan(Date value) {
            addCriterion("ffKJDate <", value, "ffkjdate");
            return (Criteria) this;
        }

        public Criteria andFfkjdateLessThanOrEqualTo(Date value) {
            addCriterion("ffKJDate <=", value, "ffkjdate");
            return (Criteria) this;
        }

        public Criteria andFfkjdateIn(List<Date> values) {
            addCriterion("ffKJDate in", values, "ffkjdate");
            return (Criteria) this;
        }

        public Criteria andFfkjdateNotIn(List<Date> values) {
            addCriterion("ffKJDate not in", values, "ffkjdate");
            return (Criteria) this;
        }

        public Criteria andFfkjdateBetween(Date value1, Date value2) {
            addCriterion("ffKJDate between", value1, value2, "ffkjdate");
            return (Criteria) this;
        }

        public Criteria andFfkjdateNotBetween(Date value1, Date value2) {
            addCriterion("ffKJDate not between", value1, value2, "ffkjdate");
            return (Criteria) this;
        }

        public Criteria andFrelationidIsNull() {
            addCriterion("fRelationID is null");
            return (Criteria) this;
        }

        public Criteria andFrelationidIsNotNull() {
            addCriterion("fRelationID is not null");
            return (Criteria) this;
        }

        public Criteria andFrelationidEqualTo(Integer value) {
            addCriterion("fRelationID =", value, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidNotEqualTo(Integer value) {
            addCriterion("fRelationID <>", value, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidGreaterThan(Integer value) {
            addCriterion("fRelationID >", value, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fRelationID >=", value, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidLessThan(Integer value) {
            addCriterion("fRelationID <", value, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidLessThanOrEqualTo(Integer value) {
            addCriterion("fRelationID <=", value, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidIn(List<Integer> values) {
            addCriterion("fRelationID in", values, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidNotIn(List<Integer> values) {
            addCriterion("fRelationID not in", values, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidBetween(Integer value1, Integer value2) {
            addCriterion("fRelationID between", value1, value2, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidNotBetween(Integer value1, Integer value2) {
            addCriterion("fRelationID not between", value1, value2, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidIsNull() {
            addCriterion("fRelationClassID is null");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidIsNotNull() {
            addCriterion("fRelationClassID is not null");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidEqualTo(Integer value) {
            addCriterion("fRelationClassID =", value, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidNotEqualTo(Integer value) {
            addCriterion("fRelationClassID <>", value, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidGreaterThan(Integer value) {
            addCriterion("fRelationClassID >", value, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fRelationClassID >=", value, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidLessThan(Integer value) {
            addCriterion("fRelationClassID <", value, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidLessThanOrEqualTo(Integer value) {
            addCriterion("fRelationClassID <=", value, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidIn(List<Integer> values) {
            addCriterion("fRelationClassID in", values, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidNotIn(List<Integer> values) {
            addCriterion("fRelationClassID not in", values, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidBetween(Integer value1, Integer value2) {
            addCriterion("fRelationClassID between", value1, value2, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidNotBetween(Integer value1, Integer value2) {
            addCriterion("fRelationClassID not between", value1, value2, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFpushdowndataIsNull() {
            addCriterion("fPushDownData is null");
            return (Criteria) this;
        }

        public Criteria andFpushdowndataIsNotNull() {
            addCriterion("fPushDownData is not null");
            return (Criteria) this;
        }

        public Criteria andFpushdowndataEqualTo(Date value) {
            addCriterion("fPushDownData =", value, "fpushdowndata");
            return (Criteria) this;
        }

        public Criteria andFpushdowndataNotEqualTo(Date value) {
            addCriterion("fPushDownData <>", value, "fpushdowndata");
            return (Criteria) this;
        }

        public Criteria andFpushdowndataGreaterThan(Date value) {
            addCriterion("fPushDownData >", value, "fpushdowndata");
            return (Criteria) this;
        }

        public Criteria andFpushdowndataGreaterThanOrEqualTo(Date value) {
            addCriterion("fPushDownData >=", value, "fpushdowndata");
            return (Criteria) this;
        }

        public Criteria andFpushdowndataLessThan(Date value) {
            addCriterion("fPushDownData <", value, "fpushdowndata");
            return (Criteria) this;
        }

        public Criteria andFpushdowndataLessThanOrEqualTo(Date value) {
            addCriterion("fPushDownData <=", value, "fpushdowndata");
            return (Criteria) this;
        }

        public Criteria andFpushdowndataIn(List<Date> values) {
            addCriterion("fPushDownData in", values, "fpushdowndata");
            return (Criteria) this;
        }

        public Criteria andFpushdowndataNotIn(List<Date> values) {
            addCriterion("fPushDownData not in", values, "fpushdowndata");
            return (Criteria) this;
        }

        public Criteria andFpushdowndataBetween(Date value1, Date value2) {
            addCriterion("fPushDownData between", value1, value2, "fpushdowndata");
            return (Criteria) this;
        }

        public Criteria andFpushdowndataNotBetween(Date value1, Date value2) {
            addCriterion("fPushDownData not between", value1, value2, "fpushdowndata");
            return (Criteria) this;
        }

        public Criteria andFscompanyidIsNull() {
            addCriterion("fSCompanyID is null");
            return (Criteria) this;
        }

        public Criteria andFscompanyidIsNotNull() {
            addCriterion("fSCompanyID is not null");
            return (Criteria) this;
        }

        public Criteria andFscompanyidEqualTo(Integer value) {
            addCriterion("fSCompanyID =", value, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidNotEqualTo(Integer value) {
            addCriterion("fSCompanyID <>", value, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidGreaterThan(Integer value) {
            addCriterion("fSCompanyID >", value, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fSCompanyID >=", value, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidLessThan(Integer value) {
            addCriterion("fSCompanyID <", value, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidLessThanOrEqualTo(Integer value) {
            addCriterion("fSCompanyID <=", value, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidIn(List<Integer> values) {
            addCriterion("fSCompanyID in", values, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidNotIn(List<Integer> values) {
            addCriterion("fSCompanyID not in", values, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidBetween(Integer value1, Integer value2) {
            addCriterion("fSCompanyID between", value1, value2, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidNotBetween(Integer value1, Integer value2) {
            addCriterion("fSCompanyID not between", value1, value2, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFsalemodeidIsNull() {
            addCriterion("fSaleModeID is null");
            return (Criteria) this;
        }

        public Criteria andFsalemodeidIsNotNull() {
            addCriterion("fSaleModeID is not null");
            return (Criteria) this;
        }

        public Criteria andFsalemodeidEqualTo(Integer value) {
            addCriterion("fSaleModeID =", value, "fsalemodeid");
            return (Criteria) this;
        }

        public Criteria andFsalemodeidNotEqualTo(Integer value) {
            addCriterion("fSaleModeID <>", value, "fsalemodeid");
            return (Criteria) this;
        }

        public Criteria andFsalemodeidGreaterThan(Integer value) {
            addCriterion("fSaleModeID >", value, "fsalemodeid");
            return (Criteria) this;
        }

        public Criteria andFsalemodeidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fSaleModeID >=", value, "fsalemodeid");
            return (Criteria) this;
        }

        public Criteria andFsalemodeidLessThan(Integer value) {
            addCriterion("fSaleModeID <", value, "fsalemodeid");
            return (Criteria) this;
        }

        public Criteria andFsalemodeidLessThanOrEqualTo(Integer value) {
            addCriterion("fSaleModeID <=", value, "fsalemodeid");
            return (Criteria) this;
        }

        public Criteria andFsalemodeidIn(List<Integer> values) {
            addCriterion("fSaleModeID in", values, "fsalemodeid");
            return (Criteria) this;
        }

        public Criteria andFsalemodeidNotIn(List<Integer> values) {
            addCriterion("fSaleModeID not in", values, "fsalemodeid");
            return (Criteria) this;
        }

        public Criteria andFsalemodeidBetween(Integer value1, Integer value2) {
            addCriterion("fSaleModeID between", value1, value2, "fsalemodeid");
            return (Criteria) this;
        }

        public Criteria andFsalemodeidNotBetween(Integer value1, Integer value2) {
            addCriterion("fSaleModeID not between", value1, value2, "fsalemodeid");
            return (Criteria) this;
        }

        public Criteria andFcardidIsNull() {
            addCriterion("fCardID is null");
            return (Criteria) this;
        }

        public Criteria andFcardidIsNotNull() {
            addCriterion("fCardID is not null");
            return (Criteria) this;
        }

        public Criteria andFcardidEqualTo(String value) {
            addCriterion("fCardID =", value, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidNotEqualTo(String value) {
            addCriterion("fCardID <>", value, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidGreaterThan(String value) {
            addCriterion("fCardID >", value, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidGreaterThanOrEqualTo(String value) {
            addCriterion("fCardID >=", value, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidLessThan(String value) {
            addCriterion("fCardID <", value, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidLessThanOrEqualTo(String value) {
            addCriterion("fCardID <=", value, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidLike(String value) {
            addCriterion("fCardID like", value, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidNotLike(String value) {
            addCriterion("fCardID not like", value, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidIn(List<String> values) {
            addCriterion("fCardID in", values, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidNotIn(List<String> values) {
            addCriterion("fCardID not in", values, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidBetween(String value1, String value2) {
            addCriterion("fCardID between", value1, value2, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFcardidNotBetween(String value1, String value2) {
            addCriterion("fCardID not between", value1, value2, "fcardid");
            return (Criteria) this;
        }

        public Criteria andFphoneIsNull() {
            addCriterion("fPhone is null");
            return (Criteria) this;
        }

        public Criteria andFphoneIsNotNull() {
            addCriterion("fPhone is not null");
            return (Criteria) this;
        }

        public Criteria andFphoneEqualTo(String value) {
            addCriterion("fPhone =", value, "fphone");
            return (Criteria) this;
        }

        public Criteria andFphoneNotEqualTo(String value) {
            addCriterion("fPhone <>", value, "fphone");
            return (Criteria) this;
        }

        public Criteria andFphoneGreaterThan(String value) {
            addCriterion("fPhone >", value, "fphone");
            return (Criteria) this;
        }

        public Criteria andFphoneGreaterThanOrEqualTo(String value) {
            addCriterion("fPhone >=", value, "fphone");
            return (Criteria) this;
        }

        public Criteria andFphoneLessThan(String value) {
            addCriterion("fPhone <", value, "fphone");
            return (Criteria) this;
        }

        public Criteria andFphoneLessThanOrEqualTo(String value) {
            addCriterion("fPhone <=", value, "fphone");
            return (Criteria) this;
        }

        public Criteria andFphoneLike(String value) {
            addCriterion("fPhone like", value, "fphone");
            return (Criteria) this;
        }

        public Criteria andFphoneNotLike(String value) {
            addCriterion("fPhone not like", value, "fphone");
            return (Criteria) this;
        }

        public Criteria andFphoneIn(List<String> values) {
            addCriterion("fPhone in", values, "fphone");
            return (Criteria) this;
        }

        public Criteria andFphoneNotIn(List<String> values) {
            addCriterion("fPhone not in", values, "fphone");
            return (Criteria) this;
        }

        public Criteria andFphoneBetween(String value1, String value2) {
            addCriterion("fPhone between", value1, value2, "fphone");
            return (Criteria) this;
        }

        public Criteria andFphoneNotBetween(String value1, String value2) {
            addCriterion("fPhone not between", value1, value2, "fphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneIsNull() {
            addCriterion("fHandPhone is null");
            return (Criteria) this;
        }

        public Criteria andFhandphoneIsNotNull() {
            addCriterion("fHandPhone is not null");
            return (Criteria) this;
        }

        public Criteria andFhandphoneEqualTo(String value) {
            addCriterion("fHandPhone =", value, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneNotEqualTo(String value) {
            addCriterion("fHandPhone <>", value, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneGreaterThan(String value) {
            addCriterion("fHandPhone >", value, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneGreaterThanOrEqualTo(String value) {
            addCriterion("fHandPhone >=", value, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneLessThan(String value) {
            addCriterion("fHandPhone <", value, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneLessThanOrEqualTo(String value) {
            addCriterion("fHandPhone <=", value, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneLike(String value) {
            addCriterion("fHandPhone like", value, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneNotLike(String value) {
            addCriterion("fHandPhone not like", value, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneIn(List<String> values) {
            addCriterion("fHandPhone in", values, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneNotIn(List<String> values) {
            addCriterion("fHandPhone not in", values, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneBetween(String value1, String value2) {
            addCriterion("fHandPhone between", value1, value2, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFhandphoneNotBetween(String value1, String value2) {
            addCriterion("fHandPhone not between", value1, value2, "fhandphone");
            return (Criteria) this;
        }

        public Criteria andFenginenoIsNull() {
            addCriterion("fEngineNO is null");
            return (Criteria) this;
        }

        public Criteria andFenginenoIsNotNull() {
            addCriterion("fEngineNO is not null");
            return (Criteria) this;
        }

        public Criteria andFenginenoEqualTo(String value) {
            addCriterion("fEngineNO =", value, "fengineno");
            return (Criteria) this;
        }

        public Criteria andFenginenoNotEqualTo(String value) {
            addCriterion("fEngineNO <>", value, "fengineno");
            return (Criteria) this;
        }

        public Criteria andFenginenoGreaterThan(String value) {
            addCriterion("fEngineNO >", value, "fengineno");
            return (Criteria) this;
        }

        public Criteria andFenginenoGreaterThanOrEqualTo(String value) {
            addCriterion("fEngineNO >=", value, "fengineno");
            return (Criteria) this;
        }

        public Criteria andFenginenoLessThan(String value) {
            addCriterion("fEngineNO <", value, "fengineno");
            return (Criteria) this;
        }

        public Criteria andFenginenoLessThanOrEqualTo(String value) {
            addCriterion("fEngineNO <=", value, "fengineno");
            return (Criteria) this;
        }

        public Criteria andFenginenoLike(String value) {
            addCriterion("fEngineNO like", value, "fengineno");
            return (Criteria) this;
        }

        public Criteria andFenginenoNotLike(String value) {
            addCriterion("fEngineNO not like", value, "fengineno");
            return (Criteria) this;
        }

        public Criteria andFenginenoIn(List<String> values) {
            addCriterion("fEngineNO in", values, "fengineno");
            return (Criteria) this;
        }

        public Criteria andFenginenoNotIn(List<String> values) {
            addCriterion("fEngineNO not in", values, "fengineno");
            return (Criteria) this;
        }

        public Criteria andFenginenoBetween(String value1, String value2) {
            addCriterion("fEngineNO between", value1, value2, "fengineno");
            return (Criteria) this;
        }

        public Criteria andFenginenoNotBetween(String value1, String value2) {
            addCriterion("fEngineNO not between", value1, value2, "fengineno");
            return (Criteria) this;
        }

        public Criteria andFclassnameIsNull() {
            addCriterion("fClassName is null");
            return (Criteria) this;
        }

        public Criteria andFclassnameIsNotNull() {
            addCriterion("fClassName is not null");
            return (Criteria) this;
        }

        public Criteria andFclassnameEqualTo(String value) {
            addCriterion("fClassName =", value, "fclassname");
            return (Criteria) this;
        }

        public Criteria andFclassnameNotEqualTo(String value) {
            addCriterion("fClassName <>", value, "fclassname");
            return (Criteria) this;
        }

        public Criteria andFclassnameGreaterThan(String value) {
            addCriterion("fClassName >", value, "fclassname");
            return (Criteria) this;
        }

        public Criteria andFclassnameGreaterThanOrEqualTo(String value) {
            addCriterion("fClassName >=", value, "fclassname");
            return (Criteria) this;
        }

        public Criteria andFclassnameLessThan(String value) {
            addCriterion("fClassName <", value, "fclassname");
            return (Criteria) this;
        }

        public Criteria andFclassnameLessThanOrEqualTo(String value) {
            addCriterion("fClassName <=", value, "fclassname");
            return (Criteria) this;
        }

        public Criteria andFclassnameLike(String value) {
            addCriterion("fClassName like", value, "fclassname");
            return (Criteria) this;
        }

        public Criteria andFclassnameNotLike(String value) {
            addCriterion("fClassName not like", value, "fclassname");
            return (Criteria) this;
        }

        public Criteria andFclassnameIn(List<String> values) {
            addCriterion("fClassName in", values, "fclassname");
            return (Criteria) this;
        }

        public Criteria andFclassnameNotIn(List<String> values) {
            addCriterion("fClassName not in", values, "fclassname");
            return (Criteria) this;
        }

        public Criteria andFclassnameBetween(String value1, String value2) {
            addCriterion("fClassName between", value1, value2, "fclassname");
            return (Criteria) this;
        }

        public Criteria andFclassnameNotBetween(String value1, String value2) {
            addCriterion("fClassName not between", value1, value2, "fclassname");
            return (Criteria) this;
        }

        public Criteria andFbrandnameIsNull() {
            addCriterion("fBrandName is null");
            return (Criteria) this;
        }

        public Criteria andFbrandnameIsNotNull() {
            addCriterion("fBrandName is not null");
            return (Criteria) this;
        }

        public Criteria andFbrandnameEqualTo(String value) {
            addCriterion("fBrandName =", value, "fbrandname");
            return (Criteria) this;
        }

        public Criteria andFbrandnameNotEqualTo(String value) {
            addCriterion("fBrandName <>", value, "fbrandname");
            return (Criteria) this;
        }

        public Criteria andFbrandnameGreaterThan(String value) {
            addCriterion("fBrandName >", value, "fbrandname");
            return (Criteria) this;
        }

        public Criteria andFbrandnameGreaterThanOrEqualTo(String value) {
            addCriterion("fBrandName >=", value, "fbrandname");
            return (Criteria) this;
        }

        public Criteria andFbrandnameLessThan(String value) {
            addCriterion("fBrandName <", value, "fbrandname");
            return (Criteria) this;
        }

        public Criteria andFbrandnameLessThanOrEqualTo(String value) {
            addCriterion("fBrandName <=", value, "fbrandname");
            return (Criteria) this;
        }

        public Criteria andFbrandnameLike(String value) {
            addCriterion("fBrandName like", value, "fbrandname");
            return (Criteria) this;
        }

        public Criteria andFbrandnameNotLike(String value) {
            addCriterion("fBrandName not like", value, "fbrandname");
            return (Criteria) this;
        }

        public Criteria andFbrandnameIn(List<String> values) {
            addCriterion("fBrandName in", values, "fbrandname");
            return (Criteria) this;
        }

        public Criteria andFbrandnameNotIn(List<String> values) {
            addCriterion("fBrandName not in", values, "fbrandname");
            return (Criteria) this;
        }

        public Criteria andFbrandnameBetween(String value1, String value2) {
            addCriterion("fBrandName between", value1, value2, "fbrandname");
            return (Criteria) this;
        }

        public Criteria andFbrandnameNotBetween(String value1, String value2) {
            addCriterion("fBrandName not between", value1, value2, "fbrandname");
            return (Criteria) this;
        }

        public Criteria andFtypeclassnameIsNull() {
            addCriterion("fTypeClassName is null");
            return (Criteria) this;
        }

        public Criteria andFtypeclassnameIsNotNull() {
            addCriterion("fTypeClassName is not null");
            return (Criteria) this;
        }

        public Criteria andFtypeclassnameEqualTo(String value) {
            addCriterion("fTypeClassName =", value, "ftypeclassname");
            return (Criteria) this;
        }

        public Criteria andFtypeclassnameNotEqualTo(String value) {
            addCriterion("fTypeClassName <>", value, "ftypeclassname");
            return (Criteria) this;
        }

        public Criteria andFtypeclassnameGreaterThan(String value) {
            addCriterion("fTypeClassName >", value, "ftypeclassname");
            return (Criteria) this;
        }

        public Criteria andFtypeclassnameGreaterThanOrEqualTo(String value) {
            addCriterion("fTypeClassName >=", value, "ftypeclassname");
            return (Criteria) this;
        }

        public Criteria andFtypeclassnameLessThan(String value) {
            addCriterion("fTypeClassName <", value, "ftypeclassname");
            return (Criteria) this;
        }

        public Criteria andFtypeclassnameLessThanOrEqualTo(String value) {
            addCriterion("fTypeClassName <=", value, "ftypeclassname");
            return (Criteria) this;
        }

        public Criteria andFtypeclassnameLike(String value) {
            addCriterion("fTypeClassName like", value, "ftypeclassname");
            return (Criteria) this;
        }

        public Criteria andFtypeclassnameNotLike(String value) {
            addCriterion("fTypeClassName not like", value, "ftypeclassname");
            return (Criteria) this;
        }

        public Criteria andFtypeclassnameIn(List<String> values) {
            addCriterion("fTypeClassName in", values, "ftypeclassname");
            return (Criteria) this;
        }

        public Criteria andFtypeclassnameNotIn(List<String> values) {
            addCriterion("fTypeClassName not in", values, "ftypeclassname");
            return (Criteria) this;
        }

        public Criteria andFtypeclassnameBetween(String value1, String value2) {
            addCriterion("fTypeClassName between", value1, value2, "ftypeclassname");
            return (Criteria) this;
        }

        public Criteria andFtypeclassnameNotBetween(String value1, String value2) {
            addCriterion("fTypeClassName not between", value1, value2, "ftypeclassname");
            return (Criteria) this;
        }

        public Criteria andFtypeidIsNull() {
            addCriterion("fTypeID is null");
            return (Criteria) this;
        }

        public Criteria andFtypeidIsNotNull() {
            addCriterion("fTypeID is not null");
            return (Criteria) this;
        }

        public Criteria andFtypeidEqualTo(Integer value) {
            addCriterion("fTypeID =", value, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFtypeidNotEqualTo(Integer value) {
            addCriterion("fTypeID <>", value, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFtypeidGreaterThan(Integer value) {
            addCriterion("fTypeID >", value, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFtypeidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fTypeID >=", value, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFtypeidLessThan(Integer value) {
            addCriterion("fTypeID <", value, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFtypeidLessThanOrEqualTo(Integer value) {
            addCriterion("fTypeID <=", value, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFtypeidIn(List<Integer> values) {
            addCriterion("fTypeID in", values, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFtypeidNotIn(List<Integer> values) {
            addCriterion("fTypeID not in", values, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFtypeidBetween(Integer value1, Integer value2) {
            addCriterion("fTypeID between", value1, value2, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFtypeidNotBetween(Integer value1, Integer value2) {
            addCriterion("fTypeID not between", value1, value2, "ftypeid");
            return (Criteria) this;
        }

        public Criteria andFmemo2IsNull() {
            addCriterion("fMemo2 is null");
            return (Criteria) this;
        }

        public Criteria andFmemo2IsNotNull() {
            addCriterion("fMemo2 is not null");
            return (Criteria) this;
        }

        public Criteria andFmemo2EqualTo(String value) {
            addCriterion("fMemo2 =", value, "fmemo2");
            return (Criteria) this;
        }

        public Criteria andFmemo2NotEqualTo(String value) {
            addCriterion("fMemo2 <>", value, "fmemo2");
            return (Criteria) this;
        }

        public Criteria andFmemo2GreaterThan(String value) {
            addCriterion("fMemo2 >", value, "fmemo2");
            return (Criteria) this;
        }

        public Criteria andFmemo2GreaterThanOrEqualTo(String value) {
            addCriterion("fMemo2 >=", value, "fmemo2");
            return (Criteria) this;
        }

        public Criteria andFmemo2LessThan(String value) {
            addCriterion("fMemo2 <", value, "fmemo2");
            return (Criteria) this;
        }

        public Criteria andFmemo2LessThanOrEqualTo(String value) {
            addCriterion("fMemo2 <=", value, "fmemo2");
            return (Criteria) this;
        }

        public Criteria andFmemo2Like(String value) {
            addCriterion("fMemo2 like", value, "fmemo2");
            return (Criteria) this;
        }

        public Criteria andFmemo2NotLike(String value) {
            addCriterion("fMemo2 not like", value, "fmemo2");
            return (Criteria) this;
        }

        public Criteria andFmemo2In(List<String> values) {
            addCriterion("fMemo2 in", values, "fmemo2");
            return (Criteria) this;
        }

        public Criteria andFmemo2NotIn(List<String> values) {
            addCriterion("fMemo2 not in", values, "fmemo2");
            return (Criteria) this;
        }

        public Criteria andFmemo2Between(String value1, String value2) {
            addCriterion("fMemo2 between", value1, value2, "fmemo2");
            return (Criteria) this;
        }

        public Criteria andFmemo2NotBetween(String value1, String value2) {
            addCriterion("fMemo2 not between", value1, value2, "fmemo2");
            return (Criteria) this;
        }

        public Criteria andFempidIsNull() {
            addCriterion("fEmpID is null");
            return (Criteria) this;
        }

        public Criteria andFempidIsNotNull() {
            addCriterion("fEmpID is not null");
            return (Criteria) this;
        }

        public Criteria andFempidEqualTo(Integer value) {
            addCriterion("fEmpID =", value, "fempid");
            return (Criteria) this;
        }

        public Criteria andFempidNotEqualTo(Integer value) {
            addCriterion("fEmpID <>", value, "fempid");
            return (Criteria) this;
        }

        public Criteria andFempidGreaterThan(Integer value) {
            addCriterion("fEmpID >", value, "fempid");
            return (Criteria) this;
        }

        public Criteria andFempidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fEmpID >=", value, "fempid");
            return (Criteria) this;
        }

        public Criteria andFempidLessThan(Integer value) {
            addCriterion("fEmpID <", value, "fempid");
            return (Criteria) this;
        }

        public Criteria andFempidLessThanOrEqualTo(Integer value) {
            addCriterion("fEmpID <=", value, "fempid");
            return (Criteria) this;
        }

        public Criteria andFempidIn(List<Integer> values) {
            addCriterion("fEmpID in", values, "fempid");
            return (Criteria) this;
        }

        public Criteria andFempidNotIn(List<Integer> values) {
            addCriterion("fEmpID not in", values, "fempid");
            return (Criteria) this;
        }

        public Criteria andFempidBetween(Integer value1, Integer value2) {
            addCriterion("fEmpID between", value1, value2, "fempid");
            return (Criteria) this;
        }

        public Criteria andFempidNotBetween(Integer value1, Integer value2) {
            addCriterion("fEmpID not between", value1, value2, "fempid");
            return (Criteria) this;
        }

        public Criteria andFemp1idIsNull() {
            addCriterion("fEmp1ID is null");
            return (Criteria) this;
        }

        public Criteria andFemp1idIsNotNull() {
            addCriterion("fEmp1ID is not null");
            return (Criteria) this;
        }

        public Criteria andFemp1idEqualTo(Integer value) {
            addCriterion("fEmp1ID =", value, "femp1id");
            return (Criteria) this;
        }

        public Criteria andFemp1idNotEqualTo(Integer value) {
            addCriterion("fEmp1ID <>", value, "femp1id");
            return (Criteria) this;
        }

        public Criteria andFemp1idGreaterThan(Integer value) {
            addCriterion("fEmp1ID >", value, "femp1id");
            return (Criteria) this;
        }

        public Criteria andFemp1idGreaterThanOrEqualTo(Integer value) {
            addCriterion("fEmp1ID >=", value, "femp1id");
            return (Criteria) this;
        }

        public Criteria andFemp1idLessThan(Integer value) {
            addCriterion("fEmp1ID <", value, "femp1id");
            return (Criteria) this;
        }

        public Criteria andFemp1idLessThanOrEqualTo(Integer value) {
            addCriterion("fEmp1ID <=", value, "femp1id");
            return (Criteria) this;
        }

        public Criteria andFemp1idIn(List<Integer> values) {
            addCriterion("fEmp1ID in", values, "femp1id");
            return (Criteria) this;
        }

        public Criteria andFemp1idNotIn(List<Integer> values) {
            addCriterion("fEmp1ID not in", values, "femp1id");
            return (Criteria) this;
        }

        public Criteria andFemp1idBetween(Integer value1, Integer value2) {
            addCriterion("fEmp1ID between", value1, value2, "femp1id");
            return (Criteria) this;
        }

        public Criteria andFemp1idNotBetween(Integer value1, Integer value2) {
            addCriterion("fEmp1ID not between", value1, value2, "femp1id");
            return (Criteria) this;
        }

        public Criteria andFoperdateIsNull() {
            addCriterion("fOperDate is null");
            return (Criteria) this;
        }

        public Criteria andFoperdateIsNotNull() {
            addCriterion("fOperDate is not null");
            return (Criteria) this;
        }

        public Criteria andFoperdateEqualTo(Date value) {
            addCriterion("fOperDate =", value, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateNotEqualTo(Date value) {
            addCriterion("fOperDate <>", value, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateGreaterThan(Date value) {
            addCriterion("fOperDate >", value, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateGreaterThanOrEqualTo(Date value) {
            addCriterion("fOperDate >=", value, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateLessThan(Date value) {
            addCriterion("fOperDate <", value, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateLessThanOrEqualTo(Date value) {
            addCriterion("fOperDate <=", value, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateIn(List<Date> values) {
            addCriterion("fOperDate in", values, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateNotIn(List<Date> values) {
            addCriterion("fOperDate not in", values, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateBetween(Date value1, Date value2) {
            addCriterion("fOperDate between", value1, value2, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateNotBetween(Date value1, Date value2) {
            addCriterion("fOperDate not between", value1, value2, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperuseridIsNull() {
            addCriterion("fOperUserID is null");
            return (Criteria) this;
        }

        public Criteria andFoperuseridIsNotNull() {
            addCriterion("fOperUserID is not null");
            return (Criteria) this;
        }

        public Criteria andFoperuseridEqualTo(Integer value) {
            addCriterion("fOperUserID =", value, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridNotEqualTo(Integer value) {
            addCriterion("fOperUserID <>", value, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridGreaterThan(Integer value) {
            addCriterion("fOperUserID >", value, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridGreaterThanOrEqualTo(Integer value) {
            addCriterion("fOperUserID >=", value, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridLessThan(Integer value) {
            addCriterion("fOperUserID <", value, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridLessThanOrEqualTo(Integer value) {
            addCriterion("fOperUserID <=", value, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridIn(List<Integer> values) {
            addCriterion("fOperUserID in", values, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridNotIn(List<Integer> values) {
            addCriterion("fOperUserID not in", values, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridBetween(Integer value1, Integer value2) {
            addCriterion("fOperUserID between", value1, value2, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridNotBetween(Integer value1, Integer value2) {
            addCriterion("fOperUserID not between", value1, value2, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFcitemidIsNull() {
            addCriterion("fCItemID is null");
            return (Criteria) this;
        }

        public Criteria andFcitemidIsNotNull() {
            addCriterion("fCItemID is not null");
            return (Criteria) this;
        }

        public Criteria andFcitemidEqualTo(Integer value) {
            addCriterion("fCItemID =", value, "fcitemid");
            return (Criteria) this;
        }

        public Criteria andFcitemidNotEqualTo(Integer value) {
            addCriterion("fCItemID <>", value, "fcitemid");
            return (Criteria) this;
        }

        public Criteria andFcitemidGreaterThan(Integer value) {
            addCriterion("fCItemID >", value, "fcitemid");
            return (Criteria) this;
        }

        public Criteria andFcitemidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fCItemID >=", value, "fcitemid");
            return (Criteria) this;
        }

        public Criteria andFcitemidLessThan(Integer value) {
            addCriterion("fCItemID <", value, "fcitemid");
            return (Criteria) this;
        }

        public Criteria andFcitemidLessThanOrEqualTo(Integer value) {
            addCriterion("fCItemID <=", value, "fcitemid");
            return (Criteria) this;
        }

        public Criteria andFcitemidIn(List<Integer> values) {
            addCriterion("fCItemID in", values, "fcitemid");
            return (Criteria) this;
        }

        public Criteria andFcitemidNotIn(List<Integer> values) {
            addCriterion("fCItemID not in", values, "fcitemid");
            return (Criteria) this;
        }

        public Criteria andFcitemidBetween(Integer value1, Integer value2) {
            addCriterion("fCItemID between", value1, value2, "fcitemid");
            return (Criteria) this;
        }

        public Criteria andFcitemidNotBetween(Integer value1, Integer value2) {
            addCriterion("fCItemID not between", value1, value2, "fcitemid");
            return (Criteria) this;
        }

        public Criteria andFtotal1IsNull() {
            addCriterion("fTotal1 is null");
            return (Criteria) this;
        }

        public Criteria andFtotal1IsNotNull() {
            addCriterion("fTotal1 is not null");
            return (Criteria) this;
        }

        public Criteria andFtotal1EqualTo(BigDecimal value) {
            addCriterion("fTotal1 =", value, "ftotal1");
            return (Criteria) this;
        }

        public Criteria andFtotal1NotEqualTo(BigDecimal value) {
            addCriterion("fTotal1 <>", value, "ftotal1");
            return (Criteria) this;
        }

        public Criteria andFtotal1GreaterThan(BigDecimal value) {
            addCriterion("fTotal1 >", value, "ftotal1");
            return (Criteria) this;
        }

        public Criteria andFtotal1GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fTotal1 >=", value, "ftotal1");
            return (Criteria) this;
        }

        public Criteria andFtotal1LessThan(BigDecimal value) {
            addCriterion("fTotal1 <", value, "ftotal1");
            return (Criteria) this;
        }

        public Criteria andFtotal1LessThanOrEqualTo(BigDecimal value) {
            addCriterion("fTotal1 <=", value, "ftotal1");
            return (Criteria) this;
        }

        public Criteria andFtotal1In(List<BigDecimal> values) {
            addCriterion("fTotal1 in", values, "ftotal1");
            return (Criteria) this;
        }

        public Criteria andFtotal1NotIn(List<BigDecimal> values) {
            addCriterion("fTotal1 not in", values, "ftotal1");
            return (Criteria) this;
        }

        public Criteria andFtotal1Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("fTotal1 between", value1, value2, "ftotal1");
            return (Criteria) this;
        }

        public Criteria andFtotal1NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fTotal1 not between", value1, value2, "ftotal1");
            return (Criteria) this;
        }

        public Criteria andFtotal3IsNull() {
            addCriterion("fTotal3 is null");
            return (Criteria) this;
        }

        public Criteria andFtotal3IsNotNull() {
            addCriterion("fTotal3 is not null");
            return (Criteria) this;
        }

        public Criteria andFtotal3EqualTo(BigDecimal value) {
            addCriterion("fTotal3 =", value, "ftotal3");
            return (Criteria) this;
        }

        public Criteria andFtotal3NotEqualTo(BigDecimal value) {
            addCriterion("fTotal3 <>", value, "ftotal3");
            return (Criteria) this;
        }

        public Criteria andFtotal3GreaterThan(BigDecimal value) {
            addCriterion("fTotal3 >", value, "ftotal3");
            return (Criteria) this;
        }

        public Criteria andFtotal3GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fTotal3 >=", value, "ftotal3");
            return (Criteria) this;
        }

        public Criteria andFtotal3LessThan(BigDecimal value) {
            addCriterion("fTotal3 <", value, "ftotal3");
            return (Criteria) this;
        }

        public Criteria andFtotal3LessThanOrEqualTo(BigDecimal value) {
            addCriterion("fTotal3 <=", value, "ftotal3");
            return (Criteria) this;
        }

        public Criteria andFtotal3In(List<BigDecimal> values) {
            addCriterion("fTotal3 in", values, "ftotal3");
            return (Criteria) this;
        }

        public Criteria andFtotal3NotIn(List<BigDecimal> values) {
            addCriterion("fTotal3 not in", values, "ftotal3");
            return (Criteria) this;
        }

        public Criteria andFtotal3Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("fTotal3 between", value1, value2, "ftotal3");
            return (Criteria) this;
        }

        public Criteria andFtotal3NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fTotal3 not between", value1, value2, "ftotal3");
            return (Criteria) this;
        }

        public Criteria andFtotal2IsNull() {
            addCriterion("fTotal2 is null");
            return (Criteria) this;
        }

        public Criteria andFtotal2IsNotNull() {
            addCriterion("fTotal2 is not null");
            return (Criteria) this;
        }

        public Criteria andFtotal2EqualTo(BigDecimal value) {
            addCriterion("fTotal2 =", value, "ftotal2");
            return (Criteria) this;
        }

        public Criteria andFtotal2NotEqualTo(BigDecimal value) {
            addCriterion("fTotal2 <>", value, "ftotal2");
            return (Criteria) this;
        }

        public Criteria andFtotal2GreaterThan(BigDecimal value) {
            addCriterion("fTotal2 >", value, "ftotal2");
            return (Criteria) this;
        }

        public Criteria andFtotal2GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fTotal2 >=", value, "ftotal2");
            return (Criteria) this;
        }

        public Criteria andFtotal2LessThan(BigDecimal value) {
            addCriterion("fTotal2 <", value, "ftotal2");
            return (Criteria) this;
        }

        public Criteria andFtotal2LessThanOrEqualTo(BigDecimal value) {
            addCriterion("fTotal2 <=", value, "ftotal2");
            return (Criteria) this;
        }

        public Criteria andFtotal2In(List<BigDecimal> values) {
            addCriterion("fTotal2 in", values, "ftotal2");
            return (Criteria) this;
        }

        public Criteria andFtotal2NotIn(List<BigDecimal> values) {
            addCriterion("fTotal2 not in", values, "ftotal2");
            return (Criteria) this;
        }

        public Criteria andFtotal2Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("fTotal2 between", value1, value2, "ftotal2");
            return (Criteria) this;
        }

        public Criteria andFtotal2NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fTotal2 not between", value1, value2, "ftotal2");
            return (Criteria) this;
        }

        public Criteria andFtotal4IsNull() {
            addCriterion("fTotal4 is null");
            return (Criteria) this;
        }

        public Criteria andFtotal4IsNotNull() {
            addCriterion("fTotal4 is not null");
            return (Criteria) this;
        }

        public Criteria andFtotal4EqualTo(BigDecimal value) {
            addCriterion("fTotal4 =", value, "ftotal4");
            return (Criteria) this;
        }

        public Criteria andFtotal4NotEqualTo(BigDecimal value) {
            addCriterion("fTotal4 <>", value, "ftotal4");
            return (Criteria) this;
        }

        public Criteria andFtotal4GreaterThan(BigDecimal value) {
            addCriterion("fTotal4 >", value, "ftotal4");
            return (Criteria) this;
        }

        public Criteria andFtotal4GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fTotal4 >=", value, "ftotal4");
            return (Criteria) this;
        }

        public Criteria andFtotal4LessThan(BigDecimal value) {
            addCriterion("fTotal4 <", value, "ftotal4");
            return (Criteria) this;
        }

        public Criteria andFtotal4LessThanOrEqualTo(BigDecimal value) {
            addCriterion("fTotal4 <=", value, "ftotal4");
            return (Criteria) this;
        }

        public Criteria andFtotal4In(List<BigDecimal> values) {
            addCriterion("fTotal4 in", values, "ftotal4");
            return (Criteria) this;
        }

        public Criteria andFtotal4NotIn(List<BigDecimal> values) {
            addCriterion("fTotal4 not in", values, "ftotal4");
            return (Criteria) this;
        }

        public Criteria andFtotal4Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("fTotal4 between", value1, value2, "ftotal4");
            return (Criteria) this;
        }

        public Criteria andFtotal4NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fTotal4 not between", value1, value2, "ftotal4");
            return (Criteria) this;
        }

        public Criteria andFplandateIsNull() {
            addCriterion("fPlanDate is null");
            return (Criteria) this;
        }

        public Criteria andFplandateIsNotNull() {
            addCriterion("fPlanDate is not null");
            return (Criteria) this;
        }

        public Criteria andFplandateEqualTo(Date value) {
            addCriterion("fPlanDate =", value, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFplandateNotEqualTo(Date value) {
            addCriterion("fPlanDate <>", value, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFplandateGreaterThan(Date value) {
            addCriterion("fPlanDate >", value, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFplandateGreaterThanOrEqualTo(Date value) {
            addCriterion("fPlanDate >=", value, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFplandateLessThan(Date value) {
            addCriterion("fPlanDate <", value, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFplandateLessThanOrEqualTo(Date value) {
            addCriterion("fPlanDate <=", value, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFplandateIn(List<Date> values) {
            addCriterion("fPlanDate in", values, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFplandateNotIn(List<Date> values) {
            addCriterion("fPlanDate not in", values, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFplandateBetween(Date value1, Date value2) {
            addCriterion("fPlanDate between", value1, value2, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFplandateNotBetween(Date value1, Date value2) {
            addCriterion("fPlanDate not between", value1, value2, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFaddressIsNull() {
            addCriterion("fAddress is null");
            return (Criteria) this;
        }

        public Criteria andFaddressIsNotNull() {
            addCriterion("fAddress is not null");
            return (Criteria) this;
        }

        public Criteria andFaddressEqualTo(String value) {
            addCriterion("fAddress =", value, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressNotEqualTo(String value) {
            addCriterion("fAddress <>", value, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressGreaterThan(String value) {
            addCriterion("fAddress >", value, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressGreaterThanOrEqualTo(String value) {
            addCriterion("fAddress >=", value, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressLessThan(String value) {
            addCriterion("fAddress <", value, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressLessThanOrEqualTo(String value) {
            addCriterion("fAddress <=", value, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressLike(String value) {
            addCriterion("fAddress like", value, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressNotLike(String value) {
            addCriterion("fAddress not like", value, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressIn(List<String> values) {
            addCriterion("fAddress in", values, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressNotIn(List<String> values) {
            addCriterion("fAddress not in", values, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressBetween(String value1, String value2) {
            addCriterion("fAddress between", value1, value2, "faddress");
            return (Criteria) this;
        }

        public Criteria andFaddressNotBetween(String value1, String value2) {
            addCriterion("fAddress not between", value1, value2, "faddress");
            return (Criteria) this;
        }

        public Criteria andFempIsNull() {
            addCriterion("fEmp is null");
            return (Criteria) this;
        }

        public Criteria andFempIsNotNull() {
            addCriterion("fEmp is not null");
            return (Criteria) this;
        }

        public Criteria andFempEqualTo(String value) {
            addCriterion("fEmp =", value, "femp");
            return (Criteria) this;
        }

        public Criteria andFempNotEqualTo(String value) {
            addCriterion("fEmp <>", value, "femp");
            return (Criteria) this;
        }

        public Criteria andFempGreaterThan(String value) {
            addCriterion("fEmp >", value, "femp");
            return (Criteria) this;
        }

        public Criteria andFempGreaterThanOrEqualTo(String value) {
            addCriterion("fEmp >=", value, "femp");
            return (Criteria) this;
        }

        public Criteria andFempLessThan(String value) {
            addCriterion("fEmp <", value, "femp");
            return (Criteria) this;
        }

        public Criteria andFempLessThanOrEqualTo(String value) {
            addCriterion("fEmp <=", value, "femp");
            return (Criteria) this;
        }

        public Criteria andFempLike(String value) {
            addCriterion("fEmp like", value, "femp");
            return (Criteria) this;
        }

        public Criteria andFempNotLike(String value) {
            addCriterion("fEmp not like", value, "femp");
            return (Criteria) this;
        }

        public Criteria andFempIn(List<String> values) {
            addCriterion("fEmp in", values, "femp");
            return (Criteria) this;
        }

        public Criteria andFempNotIn(List<String> values) {
            addCriterion("fEmp not in", values, "femp");
            return (Criteria) this;
        }

        public Criteria andFempBetween(String value1, String value2) {
            addCriterion("fEmp between", value1, value2, "femp");
            return (Criteria) this;
        }

        public Criteria andFempNotBetween(String value1, String value2) {
            addCriterion("fEmp not between", value1, value2, "femp");
            return (Criteria) this;
        }

        public Criteria andFempphoneIsNull() {
            addCriterion("fEmpPhone is null");
            return (Criteria) this;
        }

        public Criteria andFempphoneIsNotNull() {
            addCriterion("fEmpPhone is not null");
            return (Criteria) this;
        }

        public Criteria andFempphoneEqualTo(String value) {
            addCriterion("fEmpPhone =", value, "fempphone");
            return (Criteria) this;
        }

        public Criteria andFempphoneNotEqualTo(String value) {
            addCriterion("fEmpPhone <>", value, "fempphone");
            return (Criteria) this;
        }

        public Criteria andFempphoneGreaterThan(String value) {
            addCriterion("fEmpPhone >", value, "fempphone");
            return (Criteria) this;
        }

        public Criteria andFempphoneGreaterThanOrEqualTo(String value) {
            addCriterion("fEmpPhone >=", value, "fempphone");
            return (Criteria) this;
        }

        public Criteria andFempphoneLessThan(String value) {
            addCriterion("fEmpPhone <", value, "fempphone");
            return (Criteria) this;
        }

        public Criteria andFempphoneLessThanOrEqualTo(String value) {
            addCriterion("fEmpPhone <=", value, "fempphone");
            return (Criteria) this;
        }

        public Criteria andFempphoneLike(String value) {
            addCriterion("fEmpPhone like", value, "fempphone");
            return (Criteria) this;
        }

        public Criteria andFempphoneNotLike(String value) {
            addCriterion("fEmpPhone not like", value, "fempphone");
            return (Criteria) this;
        }

        public Criteria andFempphoneIn(List<String> values) {
            addCriterion("fEmpPhone in", values, "fempphone");
            return (Criteria) this;
        }

        public Criteria andFempphoneNotIn(List<String> values) {
            addCriterion("fEmpPhone not in", values, "fempphone");
            return (Criteria) this;
        }

        public Criteria andFempphoneBetween(String value1, String value2) {
            addCriterion("fEmpPhone between", value1, value2, "fempphone");
            return (Criteria) this;
        }

        public Criteria andFempphoneNotBetween(String value1, String value2) {
            addCriterion("fEmpPhone not between", value1, value2, "fempphone");
            return (Criteria) this;
        }

        public Criteria andFchr1IsNull() {
            addCriterion("fChr1 is null");
            return (Criteria) this;
        }

        public Criteria andFchr1IsNotNull() {
            addCriterion("fChr1 is not null");
            return (Criteria) this;
        }

        public Criteria andFchr1EqualTo(String value) {
            addCriterion("fChr1 =", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1NotEqualTo(String value) {
            addCriterion("fChr1 <>", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1GreaterThan(String value) {
            addCriterion("fChr1 >", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1GreaterThanOrEqualTo(String value) {
            addCriterion("fChr1 >=", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1LessThan(String value) {
            addCriterion("fChr1 <", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1LessThanOrEqualTo(String value) {
            addCriterion("fChr1 <=", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1Like(String value) {
            addCriterion("fChr1 like", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1NotLike(String value) {
            addCriterion("fChr1 not like", value, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1In(List<String> values) {
            addCriterion("fChr1 in", values, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1NotIn(List<String> values) {
            addCriterion("fChr1 not in", values, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1Between(String value1, String value2) {
            addCriterion("fChr1 between", value1, value2, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr1NotBetween(String value1, String value2) {
            addCriterion("fChr1 not between", value1, value2, "fchr1");
            return (Criteria) this;
        }

        public Criteria andFchr2IsNull() {
            addCriterion("fChr2 is null");
            return (Criteria) this;
        }

        public Criteria andFchr2IsNotNull() {
            addCriterion("fChr2 is not null");
            return (Criteria) this;
        }

        public Criteria andFchr2EqualTo(String value) {
            addCriterion("fChr2 =", value, "fchr2");
            return (Criteria) this;
        }

        public Criteria andFchr2NotEqualTo(String value) {
            addCriterion("fChr2 <>", value, "fchr2");
            return (Criteria) this;
        }

        public Criteria andFchr2GreaterThan(String value) {
            addCriterion("fChr2 >", value, "fchr2");
            return (Criteria) this;
        }

        public Criteria andFchr2GreaterThanOrEqualTo(String value) {
            addCriterion("fChr2 >=", value, "fchr2");
            return (Criteria) this;
        }

        public Criteria andFchr2LessThan(String value) {
            addCriterion("fChr2 <", value, "fchr2");
            return (Criteria) this;
        }

        public Criteria andFchr2LessThanOrEqualTo(String value) {
            addCriterion("fChr2 <=", value, "fchr2");
            return (Criteria) this;
        }

        public Criteria andFchr2Like(String value) {
            addCriterion("fChr2 like", value, "fchr2");
            return (Criteria) this;
        }

        public Criteria andFchr2NotLike(String value) {
            addCriterion("fChr2 not like", value, "fchr2");
            return (Criteria) this;
        }

        public Criteria andFchr2In(List<String> values) {
            addCriterion("fChr2 in", values, "fchr2");
            return (Criteria) this;
        }

        public Criteria andFchr2NotIn(List<String> values) {
            addCriterion("fChr2 not in", values, "fchr2");
            return (Criteria) this;
        }

        public Criteria andFchr2Between(String value1, String value2) {
            addCriterion("fChr2 between", value1, value2, "fchr2");
            return (Criteria) this;
        }

        public Criteria andFchr2NotBetween(String value1, String value2) {
            addCriterion("fChr2 not between", value1, value2, "fchr2");
            return (Criteria) this;
        }

        public Criteria andFbrandIsNull() {
            addCriterion("fBrand is null");
            return (Criteria) this;
        }

        public Criteria andFbrandIsNotNull() {
            addCriterion("fBrand is not null");
            return (Criteria) this;
        }

        public Criteria andFbrandEqualTo(String value) {
            addCriterion("fBrand =", value, "fbrand");
            return (Criteria) this;
        }

        public Criteria andFbrandNotEqualTo(String value) {
            addCriterion("fBrand <>", value, "fbrand");
            return (Criteria) this;
        }

        public Criteria andFbrandGreaterThan(String value) {
            addCriterion("fBrand >", value, "fbrand");
            return (Criteria) this;
        }

        public Criteria andFbrandGreaterThanOrEqualTo(String value) {
            addCriterion("fBrand >=", value, "fbrand");
            return (Criteria) this;
        }

        public Criteria andFbrandLessThan(String value) {
            addCriterion("fBrand <", value, "fbrand");
            return (Criteria) this;
        }

        public Criteria andFbrandLessThanOrEqualTo(String value) {
            addCriterion("fBrand <=", value, "fbrand");
            return (Criteria) this;
        }

        public Criteria andFbrandLike(String value) {
            addCriterion("fBrand like", value, "fbrand");
            return (Criteria) this;
        }

        public Criteria andFbrandNotLike(String value) {
            addCriterion("fBrand not like", value, "fbrand");
            return (Criteria) this;
        }

        public Criteria andFbrandIn(List<String> values) {
            addCriterion("fBrand in", values, "fbrand");
            return (Criteria) this;
        }

        public Criteria andFbrandNotIn(List<String> values) {
            addCriterion("fBrand not in", values, "fbrand");
            return (Criteria) this;
        }

        public Criteria andFbrandBetween(String value1, String value2) {
            addCriterion("fBrand between", value1, value2, "fbrand");
            return (Criteria) this;
        }

        public Criteria andFbrandNotBetween(String value1, String value2) {
            addCriterion("fBrand not between", value1, value2, "fbrand");
            return (Criteria) this;
        }

        public Criteria andFtypeIsNull() {
            addCriterion("fType is null");
            return (Criteria) this;
        }

        public Criteria andFtypeIsNotNull() {
            addCriterion("fType is not null");
            return (Criteria) this;
        }

        public Criteria andFtypeEqualTo(String value) {
            addCriterion("fType =", value, "ftype");
            return (Criteria) this;
        }

        public Criteria andFtypeNotEqualTo(String value) {
            addCriterion("fType <>", value, "ftype");
            return (Criteria) this;
        }

        public Criteria andFtypeGreaterThan(String value) {
            addCriterion("fType >", value, "ftype");
            return (Criteria) this;
        }

        public Criteria andFtypeGreaterThanOrEqualTo(String value) {
            addCriterion("fType >=", value, "ftype");
            return (Criteria) this;
        }

        public Criteria andFtypeLessThan(String value) {
            addCriterion("fType <", value, "ftype");
            return (Criteria) this;
        }

        public Criteria andFtypeLessThanOrEqualTo(String value) {
            addCriterion("fType <=", value, "ftype");
            return (Criteria) this;
        }

        public Criteria andFtypeLike(String value) {
            addCriterion("fType like", value, "ftype");
            return (Criteria) this;
        }

        public Criteria andFtypeNotLike(String value) {
            addCriterion("fType not like", value, "ftype");
            return (Criteria) this;
        }

        public Criteria andFtypeIn(List<String> values) {
            addCriterion("fType in", values, "ftype");
            return (Criteria) this;
        }

        public Criteria andFtypeNotIn(List<String> values) {
            addCriterion("fType not in", values, "ftype");
            return (Criteria) this;
        }

        public Criteria andFtypeBetween(String value1, String value2) {
            addCriterion("fType between", value1, value2, "ftype");
            return (Criteria) this;
        }

        public Criteria andFtypeNotBetween(String value1, String value2) {
            addCriterion("fType not between", value1, value2, "ftype");
            return (Criteria) this;
        }

        public Criteria andFmachineIsNull() {
            addCriterion("fMachine is null");
            return (Criteria) this;
        }

        public Criteria andFmachineIsNotNull() {
            addCriterion("fMachine is not null");
            return (Criteria) this;
        }

        public Criteria andFmachineEqualTo(String value) {
            addCriterion("fMachine =", value, "fmachine");
            return (Criteria) this;
        }

        public Criteria andFmachineNotEqualTo(String value) {
            addCriterion("fMachine <>", value, "fmachine");
            return (Criteria) this;
        }

        public Criteria andFmachineGreaterThan(String value) {
            addCriterion("fMachine >", value, "fmachine");
            return (Criteria) this;
        }

        public Criteria andFmachineGreaterThanOrEqualTo(String value) {
            addCriterion("fMachine >=", value, "fmachine");
            return (Criteria) this;
        }

        public Criteria andFmachineLessThan(String value) {
            addCriterion("fMachine <", value, "fmachine");
            return (Criteria) this;
        }

        public Criteria andFmachineLessThanOrEqualTo(String value) {
            addCriterion("fMachine <=", value, "fmachine");
            return (Criteria) this;
        }

        public Criteria andFmachineLike(String value) {
            addCriterion("fMachine like", value, "fmachine");
            return (Criteria) this;
        }

        public Criteria andFmachineNotLike(String value) {
            addCriterion("fMachine not like", value, "fmachine");
            return (Criteria) this;
        }

        public Criteria andFmachineIn(List<String> values) {
            addCriterion("fMachine in", values, "fmachine");
            return (Criteria) this;
        }

        public Criteria andFmachineNotIn(List<String> values) {
            addCriterion("fMachine not in", values, "fmachine");
            return (Criteria) this;
        }

        public Criteria andFmachineBetween(String value1, String value2) {
            addCriterion("fMachine between", value1, value2, "fmachine");
            return (Criteria) this;
        }

        public Criteria andFmachineNotBetween(String value1, String value2) {
            addCriterion("fMachine not between", value1, value2, "fmachine");
            return (Criteria) this;
        }

        public Criteria andFhourIsNull() {
            addCriterion("fHour is null");
            return (Criteria) this;
        }

        public Criteria andFhourIsNotNull() {
            addCriterion("fHour is not null");
            return (Criteria) this;
        }

        public Criteria andFhourEqualTo(String value) {
            addCriterion("fHour =", value, "fhour");
            return (Criteria) this;
        }

        public Criteria andFhourNotEqualTo(String value) {
            addCriterion("fHour <>", value, "fhour");
            return (Criteria) this;
        }

        public Criteria andFhourGreaterThan(String value) {
            addCriterion("fHour >", value, "fhour");
            return (Criteria) this;
        }

        public Criteria andFhourGreaterThanOrEqualTo(String value) {
            addCriterion("fHour >=", value, "fhour");
            return (Criteria) this;
        }

        public Criteria andFhourLessThan(String value) {
            addCriterion("fHour <", value, "fhour");
            return (Criteria) this;
        }

        public Criteria andFhourLessThanOrEqualTo(String value) {
            addCriterion("fHour <=", value, "fhour");
            return (Criteria) this;
        }

        public Criteria andFhourLike(String value) {
            addCriterion("fHour like", value, "fhour");
            return (Criteria) this;
        }

        public Criteria andFhourNotLike(String value) {
            addCriterion("fHour not like", value, "fhour");
            return (Criteria) this;
        }

        public Criteria andFhourIn(List<String> values) {
            addCriterion("fHour in", values, "fhour");
            return (Criteria) this;
        }

        public Criteria andFhourNotIn(List<String> values) {
            addCriterion("fHour not in", values, "fhour");
            return (Criteria) this;
        }

        public Criteria andFhourBetween(String value1, String value2) {
            addCriterion("fHour between", value1, value2, "fhour");
            return (Criteria) this;
        }

        public Criteria andFhourNotBetween(String value1, String value2) {
            addCriterion("fHour not between", value1, value2, "fhour");
            return (Criteria) this;
        }

        public Criteria andFchr3IsNull() {
            addCriterion("fChr3 is null");
            return (Criteria) this;
        }

        public Criteria andFchr3IsNotNull() {
            addCriterion("fChr3 is not null");
            return (Criteria) this;
        }

        public Criteria andFchr3EqualTo(String value) {
            addCriterion("fChr3 =", value, "fchr3");
            return (Criteria) this;
        }

        public Criteria andFchr3NotEqualTo(String value) {
            addCriterion("fChr3 <>", value, "fchr3");
            return (Criteria) this;
        }

        public Criteria andFchr3GreaterThan(String value) {
            addCriterion("fChr3 >", value, "fchr3");
            return (Criteria) this;
        }

        public Criteria andFchr3GreaterThanOrEqualTo(String value) {
            addCriterion("fChr3 >=", value, "fchr3");
            return (Criteria) this;
        }

        public Criteria andFchr3LessThan(String value) {
            addCriterion("fChr3 <", value, "fchr3");
            return (Criteria) this;
        }

        public Criteria andFchr3LessThanOrEqualTo(String value) {
            addCriterion("fChr3 <=", value, "fchr3");
            return (Criteria) this;
        }

        public Criteria andFchr3Like(String value) {
            addCriterion("fChr3 like", value, "fchr3");
            return (Criteria) this;
        }

        public Criteria andFchr3NotLike(String value) {
            addCriterion("fChr3 not like", value, "fchr3");
            return (Criteria) this;
        }

        public Criteria andFchr3In(List<String> values) {
            addCriterion("fChr3 in", values, "fchr3");
            return (Criteria) this;
        }

        public Criteria andFchr3NotIn(List<String> values) {
            addCriterion("fChr3 not in", values, "fchr3");
            return (Criteria) this;
        }

        public Criteria andFchr3Between(String value1, String value2) {
            addCriterion("fChr3 between", value1, value2, "fchr3");
            return (Criteria) this;
        }

        public Criteria andFchr3NotBetween(String value1, String value2) {
            addCriterion("fChr3 not between", value1, value2, "fchr3");
            return (Criteria) this;
        }

        public Criteria andFmoney5IsNull() {
            addCriterion("fMoney5 is null");
            return (Criteria) this;
        }

        public Criteria andFmoney5IsNotNull() {
            addCriterion("fMoney5 is not null");
            return (Criteria) this;
        }

        public Criteria andFmoney5EqualTo(BigDecimal value) {
            addCriterion("fMoney5 =", value, "fmoney5");
            return (Criteria) this;
        }

        public Criteria andFmoney5NotEqualTo(BigDecimal value) {
            addCriterion("fMoney5 <>", value, "fmoney5");
            return (Criteria) this;
        }

        public Criteria andFmoney5GreaterThan(BigDecimal value) {
            addCriterion("fMoney5 >", value, "fmoney5");
            return (Criteria) this;
        }

        public Criteria andFmoney5GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fMoney5 >=", value, "fmoney5");
            return (Criteria) this;
        }

        public Criteria andFmoney5LessThan(BigDecimal value) {
            addCriterion("fMoney5 <", value, "fmoney5");
            return (Criteria) this;
        }

        public Criteria andFmoney5LessThanOrEqualTo(BigDecimal value) {
            addCriterion("fMoney5 <=", value, "fmoney5");
            return (Criteria) this;
        }

        public Criteria andFmoney5In(List<BigDecimal> values) {
            addCriterion("fMoney5 in", values, "fmoney5");
            return (Criteria) this;
        }

        public Criteria andFmoney5NotIn(List<BigDecimal> values) {
            addCriterion("fMoney5 not in", values, "fmoney5");
            return (Criteria) this;
        }

        public Criteria andFmoney5Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("fMoney5 between", value1, value2, "fmoney5");
            return (Criteria) this;
        }

        public Criteria andFmoney5NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fMoney5 not between", value1, value2, "fmoney5");
            return (Criteria) this;
        }

        public Criteria andFmoney7IsNull() {
            addCriterion("fMoney7 is null");
            return (Criteria) this;
        }

        public Criteria andFmoney7IsNotNull() {
            addCriterion("fMoney7 is not null");
            return (Criteria) this;
        }

        public Criteria andFmoney7EqualTo(BigDecimal value) {
            addCriterion("fMoney7 =", value, "fmoney7");
            return (Criteria) this;
        }

        public Criteria andFmoney7NotEqualTo(BigDecimal value) {
            addCriterion("fMoney7 <>", value, "fmoney7");
            return (Criteria) this;
        }

        public Criteria andFmoney7GreaterThan(BigDecimal value) {
            addCriterion("fMoney7 >", value, "fmoney7");
            return (Criteria) this;
        }

        public Criteria andFmoney7GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fMoney7 >=", value, "fmoney7");
            return (Criteria) this;
        }

        public Criteria andFmoney7LessThan(BigDecimal value) {
            addCriterion("fMoney7 <", value, "fmoney7");
            return (Criteria) this;
        }

        public Criteria andFmoney7LessThanOrEqualTo(BigDecimal value) {
            addCriterion("fMoney7 <=", value, "fmoney7");
            return (Criteria) this;
        }

        public Criteria andFmoney7In(List<BigDecimal> values) {
            addCriterion("fMoney7 in", values, "fmoney7");
            return (Criteria) this;
        }

        public Criteria andFmoney7NotIn(List<BigDecimal> values) {
            addCriterion("fMoney7 not in", values, "fmoney7");
            return (Criteria) this;
        }

        public Criteria andFmoney7Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("fMoney7 between", value1, value2, "fmoney7");
            return (Criteria) this;
        }

        public Criteria andFmoney7NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fMoney7 not between", value1, value2, "fmoney7");
            return (Criteria) this;
        }

        public Criteria andFmoney4IsNull() {
            addCriterion("fMoney4 is null");
            return (Criteria) this;
        }

        public Criteria andFmoney4IsNotNull() {
            addCriterion("fMoney4 is not null");
            return (Criteria) this;
        }

        public Criteria andFmoney4EqualTo(BigDecimal value) {
            addCriterion("fMoney4 =", value, "fmoney4");
            return (Criteria) this;
        }

        public Criteria andFmoney4NotEqualTo(BigDecimal value) {
            addCriterion("fMoney4 <>", value, "fmoney4");
            return (Criteria) this;
        }

        public Criteria andFmoney4GreaterThan(BigDecimal value) {
            addCriterion("fMoney4 >", value, "fmoney4");
            return (Criteria) this;
        }

        public Criteria andFmoney4GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fMoney4 >=", value, "fmoney4");
            return (Criteria) this;
        }

        public Criteria andFmoney4LessThan(BigDecimal value) {
            addCriterion("fMoney4 <", value, "fmoney4");
            return (Criteria) this;
        }

        public Criteria andFmoney4LessThanOrEqualTo(BigDecimal value) {
            addCriterion("fMoney4 <=", value, "fmoney4");
            return (Criteria) this;
        }

        public Criteria andFmoney4In(List<BigDecimal> values) {
            addCriterion("fMoney4 in", values, "fmoney4");
            return (Criteria) this;
        }

        public Criteria andFmoney4NotIn(List<BigDecimal> values) {
            addCriterion("fMoney4 not in", values, "fmoney4");
            return (Criteria) this;
        }

        public Criteria andFmoney4Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("fMoney4 between", value1, value2, "fmoney4");
            return (Criteria) this;
        }

        public Criteria andFmoney4NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fMoney4 not between", value1, value2, "fmoney4");
            return (Criteria) this;
        }

        public Criteria andFmachineidIsNull() {
            addCriterion("fMachineID is null");
            return (Criteria) this;
        }

        public Criteria andFmachineidIsNotNull() {
            addCriterion("fMachineID is not null");
            return (Criteria) this;
        }

        public Criteria andFmachineidEqualTo(Integer value) {
            addCriterion("fMachineID =", value, "fmachineid");
            return (Criteria) this;
        }

        public Criteria andFmachineidNotEqualTo(Integer value) {
            addCriterion("fMachineID <>", value, "fmachineid");
            return (Criteria) this;
        }

        public Criteria andFmachineidGreaterThan(Integer value) {
            addCriterion("fMachineID >", value, "fmachineid");
            return (Criteria) this;
        }

        public Criteria andFmachineidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fMachineID >=", value, "fmachineid");
            return (Criteria) this;
        }

        public Criteria andFmachineidLessThan(Integer value) {
            addCriterion("fMachineID <", value, "fmachineid");
            return (Criteria) this;
        }

        public Criteria andFmachineidLessThanOrEqualTo(Integer value) {
            addCriterion("fMachineID <=", value, "fmachineid");
            return (Criteria) this;
        }

        public Criteria andFmachineidIn(List<Integer> values) {
            addCriterion("fMachineID in", values, "fmachineid");
            return (Criteria) this;
        }

        public Criteria andFmachineidNotIn(List<Integer> values) {
            addCriterion("fMachineID not in", values, "fmachineid");
            return (Criteria) this;
        }

        public Criteria andFmachineidBetween(Integer value1, Integer value2) {
            addCriterion("fMachineID between", value1, value2, "fmachineid");
            return (Criteria) this;
        }

        public Criteria andFmachineidNotBetween(Integer value1, Integer value2) {
            addCriterion("fMachineID not between", value1, value2, "fmachineid");
            return (Criteria) this;
        }

        public Criteria andFmachinetypeidIsNull() {
            addCriterion("fMachineTypeID is null");
            return (Criteria) this;
        }

        public Criteria andFmachinetypeidIsNotNull() {
            addCriterion("fMachineTypeID is not null");
            return (Criteria) this;
        }

        public Criteria andFmachinetypeidEqualTo(Integer value) {
            addCriterion("fMachineTypeID =", value, "fmachinetypeid");
            return (Criteria) this;
        }

        public Criteria andFmachinetypeidNotEqualTo(Integer value) {
            addCriterion("fMachineTypeID <>", value, "fmachinetypeid");
            return (Criteria) this;
        }

        public Criteria andFmachinetypeidGreaterThan(Integer value) {
            addCriterion("fMachineTypeID >", value, "fmachinetypeid");
            return (Criteria) this;
        }

        public Criteria andFmachinetypeidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fMachineTypeID >=", value, "fmachinetypeid");
            return (Criteria) this;
        }

        public Criteria andFmachinetypeidLessThan(Integer value) {
            addCriterion("fMachineTypeID <", value, "fmachinetypeid");
            return (Criteria) this;
        }

        public Criteria andFmachinetypeidLessThanOrEqualTo(Integer value) {
            addCriterion("fMachineTypeID <=", value, "fmachinetypeid");
            return (Criteria) this;
        }

        public Criteria andFmachinetypeidIn(List<Integer> values) {
            addCriterion("fMachineTypeID in", values, "fmachinetypeid");
            return (Criteria) this;
        }

        public Criteria andFmachinetypeidNotIn(List<Integer> values) {
            addCriterion("fMachineTypeID not in", values, "fmachinetypeid");
            return (Criteria) this;
        }

        public Criteria andFmachinetypeidBetween(Integer value1, Integer value2) {
            addCriterion("fMachineTypeID between", value1, value2, "fmachinetypeid");
            return (Criteria) this;
        }

        public Criteria andFmachinetypeidNotBetween(Integer value1, Integer value2) {
            addCriterion("fMachineTypeID not between", value1, value2, "fmachinetypeid");
            return (Criteria) this;
        }

        public Criteria andFplanidIsNull() {
            addCriterion("fPlanID is null");
            return (Criteria) this;
        }

        public Criteria andFplanidIsNotNull() {
            addCriterion("fPlanID is not null");
            return (Criteria) this;
        }

        public Criteria andFplanidEqualTo(Integer value) {
            addCriterion("fPlanID =", value, "fplanid");
            return (Criteria) this;
        }

        public Criteria andFplanidNotEqualTo(Integer value) {
            addCriterion("fPlanID <>", value, "fplanid");
            return (Criteria) this;
        }

        public Criteria andFplanidGreaterThan(Integer value) {
            addCriterion("fPlanID >", value, "fplanid");
            return (Criteria) this;
        }

        public Criteria andFplanidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fPlanID >=", value, "fplanid");
            return (Criteria) this;
        }

        public Criteria andFplanidLessThan(Integer value) {
            addCriterion("fPlanID <", value, "fplanid");
            return (Criteria) this;
        }

        public Criteria andFplanidLessThanOrEqualTo(Integer value) {
            addCriterion("fPlanID <=", value, "fplanid");
            return (Criteria) this;
        }

        public Criteria andFplanidIn(List<Integer> values) {
            addCriterion("fPlanID in", values, "fplanid");
            return (Criteria) this;
        }

        public Criteria andFplanidNotIn(List<Integer> values) {
            addCriterion("fPlanID not in", values, "fplanid");
            return (Criteria) this;
        }

        public Criteria andFplanidBetween(Integer value1, Integer value2) {
            addCriterion("fPlanID between", value1, value2, "fplanid");
            return (Criteria) this;
        }

        public Criteria andFplanidNotBetween(Integer value1, Integer value2) {
            addCriterion("fPlanID not between", value1, value2, "fplanid");
            return (Criteria) this;
        }

        public Criteria andFoldpriceIsNull() {
            addCriterion("fOldPrice is null");
            return (Criteria) this;
        }

        public Criteria andFoldpriceIsNotNull() {
            addCriterion("fOldPrice is not null");
            return (Criteria) this;
        }

        public Criteria andFoldpriceEqualTo(BigDecimal value) {
            addCriterion("fOldPrice =", value, "foldprice");
            return (Criteria) this;
        }

        public Criteria andFoldpriceNotEqualTo(BigDecimal value) {
            addCriterion("fOldPrice <>", value, "foldprice");
            return (Criteria) this;
        }

        public Criteria andFoldpriceGreaterThan(BigDecimal value) {
            addCriterion("fOldPrice >", value, "foldprice");
            return (Criteria) this;
        }

        public Criteria andFoldpriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fOldPrice >=", value, "foldprice");
            return (Criteria) this;
        }

        public Criteria andFoldpriceLessThan(BigDecimal value) {
            addCriterion("fOldPrice <", value, "foldprice");
            return (Criteria) this;
        }

        public Criteria andFoldpriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fOldPrice <=", value, "foldprice");
            return (Criteria) this;
        }

        public Criteria andFoldpriceIn(List<BigDecimal> values) {
            addCriterion("fOldPrice in", values, "foldprice");
            return (Criteria) this;
        }

        public Criteria andFoldpriceNotIn(List<BigDecimal> values) {
            addCriterion("fOldPrice not in", values, "foldprice");
            return (Criteria) this;
        }

        public Criteria andFoldpriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fOldPrice between", value1, value2, "foldprice");
            return (Criteria) this;
        }

        public Criteria andFoldpriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fOldPrice not between", value1, value2, "foldprice");
            return (Criteria) this;
        }

        public Criteria andFmoney6IsNull() {
            addCriterion("fMoney6 is null");
            return (Criteria) this;
        }

        public Criteria andFmoney6IsNotNull() {
            addCriterion("fMoney6 is not null");
            return (Criteria) this;
        }

        public Criteria andFmoney6EqualTo(BigDecimal value) {
            addCriterion("fMoney6 =", value, "fmoney6");
            return (Criteria) this;
        }

        public Criteria andFmoney6NotEqualTo(BigDecimal value) {
            addCriterion("fMoney6 <>", value, "fmoney6");
            return (Criteria) this;
        }

        public Criteria andFmoney6GreaterThan(BigDecimal value) {
            addCriterion("fMoney6 >", value, "fmoney6");
            return (Criteria) this;
        }

        public Criteria andFmoney6GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fMoney6 >=", value, "fmoney6");
            return (Criteria) this;
        }

        public Criteria andFmoney6LessThan(BigDecimal value) {
            addCriterion("fMoney6 <", value, "fmoney6");
            return (Criteria) this;
        }

        public Criteria andFmoney6LessThanOrEqualTo(BigDecimal value) {
            addCriterion("fMoney6 <=", value, "fmoney6");
            return (Criteria) this;
        }

        public Criteria andFmoney6In(List<BigDecimal> values) {
            addCriterion("fMoney6 in", values, "fmoney6");
            return (Criteria) this;
        }

        public Criteria andFmoney6NotIn(List<BigDecimal> values) {
            addCriterion("fMoney6 not in", values, "fmoney6");
            return (Criteria) this;
        }

        public Criteria andFmoney6Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("fMoney6 between", value1, value2, "fmoney6");
            return (Criteria) this;
        }

        public Criteria andFmoney6NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fMoney6 not between", value1, value2, "fmoney6");
            return (Criteria) this;
        }

        public Criteria andFuseridIsNull() {
            addCriterion("fUserID is null");
            return (Criteria) this;
        }

        public Criteria andFuseridIsNotNull() {
            addCriterion("fUserID is not null");
            return (Criteria) this;
        }

        public Criteria andFuseridEqualTo(Integer value) {
            addCriterion("fUserID =", value, "fuserid");
            return (Criteria) this;
        }

        public Criteria andFuseridNotEqualTo(Integer value) {
            addCriterion("fUserID <>", value, "fuserid");
            return (Criteria) this;
        }

        public Criteria andFuseridGreaterThan(Integer value) {
            addCriterion("fUserID >", value, "fuserid");
            return (Criteria) this;
        }

        public Criteria andFuseridGreaterThanOrEqualTo(Integer value) {
            addCriterion("fUserID >=", value, "fuserid");
            return (Criteria) this;
        }

        public Criteria andFuseridLessThan(Integer value) {
            addCriterion("fUserID <", value, "fuserid");
            return (Criteria) this;
        }

        public Criteria andFuseridLessThanOrEqualTo(Integer value) {
            addCriterion("fUserID <=", value, "fuserid");
            return (Criteria) this;
        }

        public Criteria andFuseridIn(List<Integer> values) {
            addCriterion("fUserID in", values, "fuserid");
            return (Criteria) this;
        }

        public Criteria andFuseridNotIn(List<Integer> values) {
            addCriterion("fUserID not in", values, "fuserid");
            return (Criteria) this;
        }

        public Criteria andFuseridBetween(Integer value1, Integer value2) {
            addCriterion("fUserID between", value1, value2, "fuserid");
            return (Criteria) this;
        }

        public Criteria andFuseridNotBetween(Integer value1, Integer value2) {
            addCriterion("fUserID not between", value1, value2, "fuserid");
            return (Criteria) this;
        }

        public Criteria andFplandate1IsNull() {
            addCriterion("fPlanDate1 is null");
            return (Criteria) this;
        }

        public Criteria andFplandate1IsNotNull() {
            addCriterion("fPlanDate1 is not null");
            return (Criteria) this;
        }

        public Criteria andFplandate1EqualTo(Date value) {
            addCriterion("fPlanDate1 =", value, "fplandate1");
            return (Criteria) this;
        }

        public Criteria andFplandate1NotEqualTo(Date value) {
            addCriterion("fPlanDate1 <>", value, "fplandate1");
            return (Criteria) this;
        }

        public Criteria andFplandate1GreaterThan(Date value) {
            addCriterion("fPlanDate1 >", value, "fplandate1");
            return (Criteria) this;
        }

        public Criteria andFplandate1GreaterThanOrEqualTo(Date value) {
            addCriterion("fPlanDate1 >=", value, "fplandate1");
            return (Criteria) this;
        }

        public Criteria andFplandate1LessThan(Date value) {
            addCriterion("fPlanDate1 <", value, "fplandate1");
            return (Criteria) this;
        }

        public Criteria andFplandate1LessThanOrEqualTo(Date value) {
            addCriterion("fPlanDate1 <=", value, "fplandate1");
            return (Criteria) this;
        }

        public Criteria andFplandate1In(List<Date> values) {
            addCriterion("fPlanDate1 in", values, "fplandate1");
            return (Criteria) this;
        }

        public Criteria andFplandate1NotIn(List<Date> values) {
            addCriterion("fPlanDate1 not in", values, "fplandate1");
            return (Criteria) this;
        }

        public Criteria andFplandate1Between(Date value1, Date value2) {
            addCriterion("fPlanDate1 between", value1, value2, "fplandate1");
            return (Criteria) this;
        }

        public Criteria andFplandate1NotBetween(Date value1, Date value2) {
            addCriterion("fPlanDate1 not between", value1, value2, "fplandate1");
            return (Criteria) this;
        }

        public Criteria andFplandate2IsNull() {
            addCriterion("fPlanDate2 is null");
            return (Criteria) this;
        }

        public Criteria andFplandate2IsNotNull() {
            addCriterion("fPlanDate2 is not null");
            return (Criteria) this;
        }

        public Criteria andFplandate2EqualTo(Date value) {
            addCriterion("fPlanDate2 =", value, "fplandate2");
            return (Criteria) this;
        }

        public Criteria andFplandate2NotEqualTo(Date value) {
            addCriterion("fPlanDate2 <>", value, "fplandate2");
            return (Criteria) this;
        }

        public Criteria andFplandate2GreaterThan(Date value) {
            addCriterion("fPlanDate2 >", value, "fplandate2");
            return (Criteria) this;
        }

        public Criteria andFplandate2GreaterThanOrEqualTo(Date value) {
            addCriterion("fPlanDate2 >=", value, "fplandate2");
            return (Criteria) this;
        }

        public Criteria andFplandate2LessThan(Date value) {
            addCriterion("fPlanDate2 <", value, "fplandate2");
            return (Criteria) this;
        }

        public Criteria andFplandate2LessThanOrEqualTo(Date value) {
            addCriterion("fPlanDate2 <=", value, "fplandate2");
            return (Criteria) this;
        }

        public Criteria andFplandate2In(List<Date> values) {
            addCriterion("fPlanDate2 in", values, "fplandate2");
            return (Criteria) this;
        }

        public Criteria andFplandate2NotIn(List<Date> values) {
            addCriterion("fPlanDate2 not in", values, "fplandate2");
            return (Criteria) this;
        }

        public Criteria andFplandate2Between(Date value1, Date value2) {
            addCriterion("fPlanDate2 between", value1, value2, "fplandate2");
            return (Criteria) this;
        }

        public Criteria andFplandate2NotBetween(Date value1, Date value2) {
            addCriterion("fPlanDate2 not between", value1, value2, "fplandate2");
            return (Criteria) this;
        }

        public Criteria andFplandate3IsNull() {
            addCriterion("fPlanDate3 is null");
            return (Criteria) this;
        }

        public Criteria andFplandate3IsNotNull() {
            addCriterion("fPlanDate3 is not null");
            return (Criteria) this;
        }

        public Criteria andFplandate3EqualTo(Date value) {
            addCriterion("fPlanDate3 =", value, "fplandate3");
            return (Criteria) this;
        }

        public Criteria andFplandate3NotEqualTo(Date value) {
            addCriterion("fPlanDate3 <>", value, "fplandate3");
            return (Criteria) this;
        }

        public Criteria andFplandate3GreaterThan(Date value) {
            addCriterion("fPlanDate3 >", value, "fplandate3");
            return (Criteria) this;
        }

        public Criteria andFplandate3GreaterThanOrEqualTo(Date value) {
            addCriterion("fPlanDate3 >=", value, "fplandate3");
            return (Criteria) this;
        }

        public Criteria andFplandate3LessThan(Date value) {
            addCriterion("fPlanDate3 <", value, "fplandate3");
            return (Criteria) this;
        }

        public Criteria andFplandate3LessThanOrEqualTo(Date value) {
            addCriterion("fPlanDate3 <=", value, "fplandate3");
            return (Criteria) this;
        }

        public Criteria andFplandate3In(List<Date> values) {
            addCriterion("fPlanDate3 in", values, "fplandate3");
            return (Criteria) this;
        }

        public Criteria andFplandate3NotIn(List<Date> values) {
            addCriterion("fPlanDate3 not in", values, "fplandate3");
            return (Criteria) this;
        }

        public Criteria andFplandate3Between(Date value1, Date value2) {
            addCriterion("fPlanDate3 between", value1, value2, "fplandate3");
            return (Criteria) this;
        }

        public Criteria andFplandate3NotBetween(Date value1, Date value2) {
            addCriterion("fPlanDate3 not between", value1, value2, "fplandate3");
            return (Criteria) this;
        }

        public Criteria andFplandate4IsNull() {
            addCriterion("fPlanDate4 is null");
            return (Criteria) this;
        }

        public Criteria andFplandate4IsNotNull() {
            addCriterion("fPlanDate4 is not null");
            return (Criteria) this;
        }

        public Criteria andFplandate4EqualTo(Date value) {
            addCriterion("fPlanDate4 =", value, "fplandate4");
            return (Criteria) this;
        }

        public Criteria andFplandate4NotEqualTo(Date value) {
            addCriterion("fPlanDate4 <>", value, "fplandate4");
            return (Criteria) this;
        }

        public Criteria andFplandate4GreaterThan(Date value) {
            addCriterion("fPlanDate4 >", value, "fplandate4");
            return (Criteria) this;
        }

        public Criteria andFplandate4GreaterThanOrEqualTo(Date value) {
            addCriterion("fPlanDate4 >=", value, "fplandate4");
            return (Criteria) this;
        }

        public Criteria andFplandate4LessThan(Date value) {
            addCriterion("fPlanDate4 <", value, "fplandate4");
            return (Criteria) this;
        }

        public Criteria andFplandate4LessThanOrEqualTo(Date value) {
            addCriterion("fPlanDate4 <=", value, "fplandate4");
            return (Criteria) this;
        }

        public Criteria andFplandate4In(List<Date> values) {
            addCriterion("fPlanDate4 in", values, "fplandate4");
            return (Criteria) this;
        }

        public Criteria andFplandate4NotIn(List<Date> values) {
            addCriterion("fPlanDate4 not in", values, "fplandate4");
            return (Criteria) this;
        }

        public Criteria andFplandate4Between(Date value1, Date value2) {
            addCriterion("fPlanDate4 between", value1, value2, "fplandate4");
            return (Criteria) this;
        }

        public Criteria andFplandate4NotBetween(Date value1, Date value2) {
            addCriterion("fPlanDate4 not between", value1, value2, "fplandate4");
            return (Criteria) this;
        }

        public Criteria andFtotal5IsNull() {
            addCriterion("fTotal5 is null");
            return (Criteria) this;
        }

        public Criteria andFtotal5IsNotNull() {
            addCriterion("fTotal5 is not null");
            return (Criteria) this;
        }

        public Criteria andFtotal5EqualTo(BigDecimal value) {
            addCriterion("fTotal5 =", value, "ftotal5");
            return (Criteria) this;
        }

        public Criteria andFtotal5NotEqualTo(BigDecimal value) {
            addCriterion("fTotal5 <>", value, "ftotal5");
            return (Criteria) this;
        }

        public Criteria andFtotal5GreaterThan(BigDecimal value) {
            addCriterion("fTotal5 >", value, "ftotal5");
            return (Criteria) this;
        }

        public Criteria andFtotal5GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fTotal5 >=", value, "ftotal5");
            return (Criteria) this;
        }

        public Criteria andFtotal5LessThan(BigDecimal value) {
            addCriterion("fTotal5 <", value, "ftotal5");
            return (Criteria) this;
        }

        public Criteria andFtotal5LessThanOrEqualTo(BigDecimal value) {
            addCriterion("fTotal5 <=", value, "ftotal5");
            return (Criteria) this;
        }

        public Criteria andFtotal5In(List<BigDecimal> values) {
            addCriterion("fTotal5 in", values, "ftotal5");
            return (Criteria) this;
        }

        public Criteria andFtotal5NotIn(List<BigDecimal> values) {
            addCriterion("fTotal5 not in", values, "ftotal5");
            return (Criteria) this;
        }

        public Criteria andFtotal5Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("fTotal5 between", value1, value2, "ftotal5");
            return (Criteria) this;
        }

        public Criteria andFtotal5NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fTotal5 not between", value1, value2, "ftotal5");
            return (Criteria) this;
        }

        public Criteria andFplandate5IsNull() {
            addCriterion("fPlanDate5 is null");
            return (Criteria) this;
        }

        public Criteria andFplandate5IsNotNull() {
            addCriterion("fPlanDate5 is not null");
            return (Criteria) this;
        }

        public Criteria andFplandate5EqualTo(Date value) {
            addCriterion("fPlanDate5 =", value, "fplandate5");
            return (Criteria) this;
        }

        public Criteria andFplandate5NotEqualTo(Date value) {
            addCriterion("fPlanDate5 <>", value, "fplandate5");
            return (Criteria) this;
        }

        public Criteria andFplandate5GreaterThan(Date value) {
            addCriterion("fPlanDate5 >", value, "fplandate5");
            return (Criteria) this;
        }

        public Criteria andFplandate5GreaterThanOrEqualTo(Date value) {
            addCriterion("fPlanDate5 >=", value, "fplandate5");
            return (Criteria) this;
        }

        public Criteria andFplandate5LessThan(Date value) {
            addCriterion("fPlanDate5 <", value, "fplandate5");
            return (Criteria) this;
        }

        public Criteria andFplandate5LessThanOrEqualTo(Date value) {
            addCriterion("fPlanDate5 <=", value, "fplandate5");
            return (Criteria) this;
        }

        public Criteria andFplandate5In(List<Date> values) {
            addCriterion("fPlanDate5 in", values, "fplandate5");
            return (Criteria) this;
        }

        public Criteria andFplandate5NotIn(List<Date> values) {
            addCriterion("fPlanDate5 not in", values, "fplandate5");
            return (Criteria) this;
        }

        public Criteria andFplandate5Between(Date value1, Date value2) {
            addCriterion("fPlanDate5 between", value1, value2, "fplandate5");
            return (Criteria) this;
        }

        public Criteria andFplandate5NotBetween(Date value1, Date value2) {
            addCriterion("fPlanDate5 not between", value1, value2, "fplandate5");
            return (Criteria) this;
        }

        public Criteria andFselltbmoneyIsNull() {
            addCriterion("fSellTBMoney is null");
            return (Criteria) this;
        }

        public Criteria andFselltbmoneyIsNotNull() {
            addCriterion("fSellTBMoney is not null");
            return (Criteria) this;
        }

        public Criteria andFselltbmoneyEqualTo(BigDecimal value) {
            addCriterion("fSellTBMoney =", value, "fselltbmoney");
            return (Criteria) this;
        }

        public Criteria andFselltbmoneyNotEqualTo(BigDecimal value) {
            addCriterion("fSellTBMoney <>", value, "fselltbmoney");
            return (Criteria) this;
        }

        public Criteria andFselltbmoneyGreaterThan(BigDecimal value) {
            addCriterion("fSellTBMoney >", value, "fselltbmoney");
            return (Criteria) this;
        }

        public Criteria andFselltbmoneyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fSellTBMoney >=", value, "fselltbmoney");
            return (Criteria) this;
        }

        public Criteria andFselltbmoneyLessThan(BigDecimal value) {
            addCriterion("fSellTBMoney <", value, "fselltbmoney");
            return (Criteria) this;
        }

        public Criteria andFselltbmoneyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fSellTBMoney <=", value, "fselltbmoney");
            return (Criteria) this;
        }

        public Criteria andFselltbmoneyIn(List<BigDecimal> values) {
            addCriterion("fSellTBMoney in", values, "fselltbmoney");
            return (Criteria) this;
        }

        public Criteria andFselltbmoneyNotIn(List<BigDecimal> values) {
            addCriterion("fSellTBMoney not in", values, "fselltbmoney");
            return (Criteria) this;
        }

        public Criteria andFselltbmoneyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fSellTBMoney between", value1, value2, "fselltbmoney");
            return (Criteria) this;
        }

        public Criteria andFselltbmoneyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fSellTBMoney not between", value1, value2, "fselltbmoney");
            return (Criteria) this;
        }

        public Criteria andFtotal6IsNull() {
            addCriterion("fTotal6 is null");
            return (Criteria) this;
        }

        public Criteria andFtotal6IsNotNull() {
            addCriterion("fTotal6 is not null");
            return (Criteria) this;
        }

        public Criteria andFtotal6EqualTo(BigDecimal value) {
            addCriterion("fTotal6 =", value, "ftotal6");
            return (Criteria) this;
        }

        public Criteria andFtotal6NotEqualTo(BigDecimal value) {
            addCriterion("fTotal6 <>", value, "ftotal6");
            return (Criteria) this;
        }

        public Criteria andFtotal6GreaterThan(BigDecimal value) {
            addCriterion("fTotal6 >", value, "ftotal6");
            return (Criteria) this;
        }

        public Criteria andFtotal6GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fTotal6 >=", value, "ftotal6");
            return (Criteria) this;
        }

        public Criteria andFtotal6LessThan(BigDecimal value) {
            addCriterion("fTotal6 <", value, "ftotal6");
            return (Criteria) this;
        }

        public Criteria andFtotal6LessThanOrEqualTo(BigDecimal value) {
            addCriterion("fTotal6 <=", value, "ftotal6");
            return (Criteria) this;
        }

        public Criteria andFtotal6In(List<BigDecimal> values) {
            addCriterion("fTotal6 in", values, "ftotal6");
            return (Criteria) this;
        }

        public Criteria andFtotal6NotIn(List<BigDecimal> values) {
            addCriterion("fTotal6 not in", values, "ftotal6");
            return (Criteria) this;
        }

        public Criteria andFtotal6Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("fTotal6 between", value1, value2, "ftotal6");
            return (Criteria) this;
        }

        public Criteria andFtotal6NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fTotal6 not between", value1, value2, "ftotal6");
            return (Criteria) this;
        }

        public Criteria andFcheckeridIsNull() {
            addCriterion("fCheckerID is null");
            return (Criteria) this;
        }

        public Criteria andFcheckeridIsNotNull() {
            addCriterion("fCheckerID is not null");
            return (Criteria) this;
        }

        public Criteria andFcheckeridEqualTo(Integer value) {
            addCriterion("fCheckerID =", value, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFcheckeridNotEqualTo(Integer value) {
            addCriterion("fCheckerID <>", value, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFcheckeridGreaterThan(Integer value) {
            addCriterion("fCheckerID >", value, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFcheckeridGreaterThanOrEqualTo(Integer value) {
            addCriterion("fCheckerID >=", value, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFcheckeridLessThan(Integer value) {
            addCriterion("fCheckerID <", value, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFcheckeridLessThanOrEqualTo(Integer value) {
            addCriterion("fCheckerID <=", value, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFcheckeridIn(List<Integer> values) {
            addCriterion("fCheckerID in", values, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFcheckeridNotIn(List<Integer> values) {
            addCriterion("fCheckerID not in", values, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFcheckeridBetween(Integer value1, Integer value2) {
            addCriterion("fCheckerID between", value1, value2, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFcheckeridNotBetween(Integer value1, Integer value2) {
            addCriterion("fCheckerID not between", value1, value2, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFcheckerdateIsNull() {
            addCriterion("fCheckerDate is null");
            return (Criteria) this;
        }

        public Criteria andFcheckerdateIsNotNull() {
            addCriterion("fCheckerDate is not null");
            return (Criteria) this;
        }

        public Criteria andFcheckerdateEqualTo(Date value) {
            addCriterion("fCheckerDate =", value, "fcheckerdate");
            return (Criteria) this;
        }

        public Criteria andFcheckerdateNotEqualTo(Date value) {
            addCriterion("fCheckerDate <>", value, "fcheckerdate");
            return (Criteria) this;
        }

        public Criteria andFcheckerdateGreaterThan(Date value) {
            addCriterion("fCheckerDate >", value, "fcheckerdate");
            return (Criteria) this;
        }

        public Criteria andFcheckerdateGreaterThanOrEqualTo(Date value) {
            addCriterion("fCheckerDate >=", value, "fcheckerdate");
            return (Criteria) this;
        }

        public Criteria andFcheckerdateLessThan(Date value) {
            addCriterion("fCheckerDate <", value, "fcheckerdate");
            return (Criteria) this;
        }

        public Criteria andFcheckerdateLessThanOrEqualTo(Date value) {
            addCriterion("fCheckerDate <=", value, "fcheckerdate");
            return (Criteria) this;
        }

        public Criteria andFcheckerdateIn(List<Date> values) {
            addCriterion("fCheckerDate in", values, "fcheckerdate");
            return (Criteria) this;
        }

        public Criteria andFcheckerdateNotIn(List<Date> values) {
            addCriterion("fCheckerDate not in", values, "fcheckerdate");
            return (Criteria) this;
        }

        public Criteria andFcheckerdateBetween(Date value1, Date value2) {
            addCriterion("fCheckerDate between", value1, value2, "fcheckerdate");
            return (Criteria) this;
        }

        public Criteria andFcheckerdateNotBetween(Date value1, Date value2) {
            addCriterion("fCheckerDate not between", value1, value2, "fcheckerdate");
            return (Criteria) this;
        }

        public Criteria andFmenderidIsNull() {
            addCriterion("fMenderID is null");
            return (Criteria) this;
        }

        public Criteria andFmenderidIsNotNull() {
            addCriterion("fMenderID is not null");
            return (Criteria) this;
        }

        public Criteria andFmenderidEqualTo(Integer value) {
            addCriterion("fMenderID =", value, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFmenderidNotEqualTo(Integer value) {
            addCriterion("fMenderID <>", value, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFmenderidGreaterThan(Integer value) {
            addCriterion("fMenderID >", value, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFmenderidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fMenderID >=", value, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFmenderidLessThan(Integer value) {
            addCriterion("fMenderID <", value, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFmenderidLessThanOrEqualTo(Integer value) {
            addCriterion("fMenderID <=", value, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFmenderidIn(List<Integer> values) {
            addCriterion("fMenderID in", values, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFmenderidNotIn(List<Integer> values) {
            addCriterion("fMenderID not in", values, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFmenderidBetween(Integer value1, Integer value2) {
            addCriterion("fMenderID between", value1, value2, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFmenderidNotBetween(Integer value1, Integer value2) {
            addCriterion("fMenderID not between", value1, value2, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFmodifydateIsNull() {
            addCriterion("fModifyDate is null");
            return (Criteria) this;
        }

        public Criteria andFmodifydateIsNotNull() {
            addCriterion("fModifyDate is not null");
            return (Criteria) this;
        }

        public Criteria andFmodifydateEqualTo(Date value) {
            addCriterion("fModifyDate =", value, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFmodifydateNotEqualTo(Date value) {
            addCriterion("fModifyDate <>", value, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFmodifydateGreaterThan(Date value) {
            addCriterion("fModifyDate >", value, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFmodifydateGreaterThanOrEqualTo(Date value) {
            addCriterion("fModifyDate >=", value, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFmodifydateLessThan(Date value) {
            addCriterion("fModifyDate <", value, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFmodifydateLessThanOrEqualTo(Date value) {
            addCriterion("fModifyDate <=", value, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFmodifydateIn(List<Date> values) {
            addCriterion("fModifyDate in", values, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFmodifydateNotIn(List<Date> values) {
            addCriterion("fModifyDate not in", values, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFmodifydateBetween(Date value1, Date value2) {
            addCriterion("fModifyDate between", value1, value2, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFmodifydateNotBetween(Date value1, Date value2) {
            addCriterion("fModifyDate not between", value1, value2, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFcreatoridIsNull() {
            addCriterion("fCreatorID is null");
            return (Criteria) this;
        }

        public Criteria andFcreatoridIsNotNull() {
            addCriterion("fCreatorID is not null");
            return (Criteria) this;
        }

        public Criteria andFcreatoridEqualTo(Integer value) {
            addCriterion("fCreatorID =", value, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFcreatoridNotEqualTo(Integer value) {
            addCriterion("fCreatorID <>", value, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFcreatoridGreaterThan(Integer value) {
            addCriterion("fCreatorID >", value, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFcreatoridGreaterThanOrEqualTo(Integer value) {
            addCriterion("fCreatorID >=", value, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFcreatoridLessThan(Integer value) {
            addCriterion("fCreatorID <", value, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFcreatoridLessThanOrEqualTo(Integer value) {
            addCriterion("fCreatorID <=", value, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFcreatoridIn(List<Integer> values) {
            addCriterion("fCreatorID in", values, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFcreatoridNotIn(List<Integer> values) {
            addCriterion("fCreatorID not in", values, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFcreatoridBetween(Integer value1, Integer value2) {
            addCriterion("fCreatorID between", value1, value2, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFcreatoridNotBetween(Integer value1, Integer value2) {
            addCriterion("fCreatorID not between", value1, value2, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFcreatedateIsNull() {
            addCriterion("fCreateDate is null");
            return (Criteria) this;
        }

        public Criteria andFcreatedateIsNotNull() {
            addCriterion("fCreateDate is not null");
            return (Criteria) this;
        }

        public Criteria andFcreatedateEqualTo(Date value) {
            addCriterion("fCreateDate =", value, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFcreatedateNotEqualTo(Date value) {
            addCriterion("fCreateDate <>", value, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFcreatedateGreaterThan(Date value) {
            addCriterion("fCreateDate >", value, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFcreatedateGreaterThanOrEqualTo(Date value) {
            addCriterion("fCreateDate >=", value, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFcreatedateLessThan(Date value) {
            addCriterion("fCreateDate <", value, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFcreatedateLessThanOrEqualTo(Date value) {
            addCriterion("fCreateDate <=", value, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFcreatedateIn(List<Date> values) {
            addCriterion("fCreateDate in", values, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFcreatedateNotIn(List<Date> values) {
            addCriterion("fCreateDate not in", values, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFcreatedateBetween(Date value1, Date value2) {
            addCriterion("fCreateDate between", value1, value2, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFcreatedateNotBetween(Date value1, Date value2) {
            addCriterion("fCreateDate not between", value1, value2, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateIsNull() {
            addCriterion("fCheckDate is null");
            return (Criteria) this;
        }

        public Criteria andFcheckdateIsNotNull() {
            addCriterion("fCheckDate is not null");
            return (Criteria) this;
        }

        public Criteria andFcheckdateEqualTo(Date value) {
            addCriterion("fCheckDate =", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateNotEqualTo(Date value) {
            addCriterion("fCheckDate <>", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateGreaterThan(Date value) {
            addCriterion("fCheckDate >", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateGreaterThanOrEqualTo(Date value) {
            addCriterion("fCheckDate >=", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateLessThan(Date value) {
            addCriterion("fCheckDate <", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateLessThanOrEqualTo(Date value) {
            addCriterion("fCheckDate <=", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateIn(List<Date> values) {
            addCriterion("fCheckDate in", values, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateNotIn(List<Date> values) {
            addCriterion("fCheckDate not in", values, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateBetween(Date value1, Date value2) {
            addCriterion("fCheckDate between", value1, value2, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateNotBetween(Date value1, Date value2) {
            addCriterion("fCheckDate not between", value1, value2, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFinteridIsNull() {
            addCriterion("fInterID is null");
            return (Criteria) this;
        }

        public Criteria andFinteridIsNotNull() {
            addCriterion("fInterID is not null");
            return (Criteria) this;
        }

        public Criteria andFinteridEqualTo(Integer value) {
            addCriterion("fInterID =", value, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridNotEqualTo(Integer value) {
            addCriterion("fInterID <>", value, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridGreaterThan(Integer value) {
            addCriterion("fInterID >", value, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridGreaterThanOrEqualTo(Integer value) {
            addCriterion("fInterID >=", value, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridLessThan(Integer value) {
            addCriterion("fInterID <", value, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridLessThanOrEqualTo(Integer value) {
            addCriterion("fInterID <=", value, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridIn(List<Integer> values) {
            addCriterion("fInterID in", values, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridNotIn(List<Integer> values) {
            addCriterion("fInterID not in", values, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridBetween(Integer value1, Integer value2) {
            addCriterion("fInterID between", value1, value2, "finterid");
            return (Criteria) this;
        }

        public Criteria andFinteridNotBetween(Integer value1, Integer value2) {
            addCriterion("fInterID not between", value1, value2, "finterid");
            return (Criteria) this;
        }

        public Criteria andFentryidIsNull() {
            addCriterion("fEntryID is null");
            return (Criteria) this;
        }

        public Criteria andFentryidIsNotNull() {
            addCriterion("fEntryID is not null");
            return (Criteria) this;
        }

        public Criteria andFentryidEqualTo(Integer value) {
            addCriterion("fEntryID =", value, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidNotEqualTo(Integer value) {
            addCriterion("fEntryID <>", value, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidGreaterThan(Integer value) {
            addCriterion("fEntryID >", value, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fEntryID >=", value, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidLessThan(Integer value) {
            addCriterion("fEntryID <", value, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidLessThanOrEqualTo(Integer value) {
            addCriterion("fEntryID <=", value, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidIn(List<Integer> values) {
            addCriterion("fEntryID in", values, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidNotIn(List<Integer> values) {
            addCriterion("fEntryID not in", values, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidBetween(Integer value1, Integer value2) {
            addCriterion("fEntryID between", value1, value2, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFentryidNotBetween(Integer value1, Integer value2) {
            addCriterion("fEntryID not between", value1, value2, "fentryid");
            return (Criteria) this;
        }

        public Criteria andFpaydateIsNull() {
            addCriterion("fPayDate is null");
            return (Criteria) this;
        }

        public Criteria andFpaydateIsNotNull() {
            addCriterion("fPayDate is not null");
            return (Criteria) this;
        }

        public Criteria andFpaydateEqualTo(Date value) {
            addCriterion("fPayDate =", value, "fpaydate");
            return (Criteria) this;
        }

        public Criteria andFpaydateNotEqualTo(Date value) {
            addCriterion("fPayDate <>", value, "fpaydate");
            return (Criteria) this;
        }

        public Criteria andFpaydateGreaterThan(Date value) {
            addCriterion("fPayDate >", value, "fpaydate");
            return (Criteria) this;
        }

        public Criteria andFpaydateGreaterThanOrEqualTo(Date value) {
            addCriterion("fPayDate >=", value, "fpaydate");
            return (Criteria) this;
        }

        public Criteria andFpaydateLessThan(Date value) {
            addCriterion("fPayDate <", value, "fpaydate");
            return (Criteria) this;
        }

        public Criteria andFpaydateLessThanOrEqualTo(Date value) {
            addCriterion("fPayDate <=", value, "fpaydate");
            return (Criteria) this;
        }

        public Criteria andFpaydateIn(List<Date> values) {
            addCriterion("fPayDate in", values, "fpaydate");
            return (Criteria) this;
        }

        public Criteria andFpaydateNotIn(List<Date> values) {
            addCriterion("fPayDate not in", values, "fpaydate");
            return (Criteria) this;
        }

        public Criteria andFpaydateBetween(Date value1, Date value2) {
            addCriterion("fPayDate between", value1, value2, "fpaydate");
            return (Criteria) this;
        }

        public Criteria andFpaydateNotBetween(Date value1, Date value2) {
            addCriterion("fPayDate not between", value1, value2, "fpaydate");
            return (Criteria) this;
        }

        public Criteria andFdetailEqualTo(int value) {
            addCriterion("fDetail =", value, "fdetail");
            return (Criteria) this;
        }

        public Criteria andFdetailNotEqualTo(int value) {
            addCriterion("fDetail <>", value, "fdetail");
            return (Criteria) this;
        }

        public Criteria andFdetailGreaterThan(int value) {
            addCriterion("fDetail >", value, "fdetail");
            return (Criteria) this;
        }

        public Criteria andFdetailGreaterThanOrEqualTo(int value) {
            addCriterion("fDetail >=", value, "fdetail");
            return (Criteria) this;
        }

        public Criteria andFdetailLessThan(int value) {
            addCriterion("fDetail <", value, "fdetail");
            return (Criteria) this;
        }

        public Criteria andFdetailLessThanOrEqualTo(int value) {
            addCriterion("fDetail <=", value, "fdetail");
            return (Criteria) this;
        }

        public Criteria andFdetailBetween(int value1, int value2) {
            addCriterion("fDetail between", value1, value2, "fdetail");
            return (Criteria) this;
        }

        public Criteria andFdetailNotBetween(int value1, int value2) {
            addCriterion("fDetail not between", value1, value2, "fdetail");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}